job sql server don´t work

[Mikael Hellström]

Hi, im running windows 2000 and sql server 2000
I have added a job to my database on a 5 minute run schedule.
The TSQL statement you can find below

DELETE FROM online
WHERE (DATEDIFF(n, tid, GETDATE()) > 25)

But it don´t fire at all. Any now why?

Regards Mikael

[CJM]

I would post the question in one of the .sqlserver.* groups..

CJM

"Mikael Hellström" <micke.hellstrom@telia.com> wrote in message
news:20okc.91244$dP1.280487@newsc.telia.net...

> Hi, im running windows 2000 and sql server 2000
> I have added a job to my database on a 5 minute run schedule.
> The TSQL statement you can find below
>
> DELETE FROM online
> WHERE (DATEDIFF(n, tid, GETDATE()) > 25)
>
> But it don´t fire at all. Any now why?
>
> Regards Mikael
>
>

[Bob Barrows]

Mikael Hellström wrote:

> Hi, im running windows 2000 and sql server 2000
> I have added a job to my database on a 5 minute run schedule.
> The TSQL statement you can find below
>
> DELETE FROM online
> WHERE (DATEDIFF(n, tid, GETDATE()) > 25)
>
> But it don´t fire at all. Any now why?
>
> Regards Mikael

I agree that you should post more details (is the job enabled? does anything
show up in the View History dialog? This will tell us if the job ran but
failed. Are there any entries about the job in the SQL error log or the
Windows Event Viewer?) to a sqlserver group. But I do want to comment on
that WHERE clause:

By using a function with a column as an argument, you are forcing a scan to
be made. This would be much more efficient:

WHERE tid > DATEADD(n,-25,GETDATE())

Now, if there is an index on tid, the index can be used. Look up "sargable"
in Google for more information.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"