Is the job running to the schedule that appears to be disabled (with the same frequency and at the same times)?  Have you run the sysjobhistory query I posted earlier...

Not that many rows, then.  But not much we can do without the execution plan.  Have you used sp_whoisactive to check for blocking while the query is running?

John

This will ready your table only once, instead of twice as your query does.  I think there'll be extra sort operations, though, so you'll want to test whether the IO...

This will tell you who is running the job - that may give you a clue to how the job is being run.  (Don't forget to substitute in the name...

Javed

Please post the actual (not estimated) execution plan.  How many rows are in each table?

John

SELECT
     a.name AS AlertName
,    j.name AS JobName
,    s.step_id
,    s.command
FROM msdb.dbo.sysalerts a
JOIN msdb.dbo.sysjobs j ON a.job_id = j.job_id
JOIN msdb.dbo.sysjobsteps s ON j.job_id = s.job_id

Mike

The best way to find out is to try it!  From my experience, the answer to all your questions is yes.

John

Jon

No, you can't do that, since MTH_NUM is not guaranteed to have been evaluated when the CASE expression is evaluated.  You'll either need to repeat the whole DATEPART...

Sanaz

Go to Linked Servers in Object Explorer, then open Object Explorer Details you can then select all the linked servers and hence script them out in one go. ...

Why would anyone do that?!  I think it's going to be messy.  You can use the sys.sql_modules catalog view to find all objects that have the word "customer" in their...

SELECT
    PartNo
,    MAX(Status) AS MaxStatus
,    MIN(Status) AS MinStatus
FROM Parts
GROUP BY PartNo
HAVING MaxStatus = 'Open'
AND MinStatus = 'Open'';

John

Yes, you can do that, but you have to use "LIKE" instead of "=".  What are your expected results?

John