question

rakeshsingh1983 avatar image
rakeshsingh1983 asked

SQL AGENT JOB

SQL Server Scheduled Job - says its running with no errors but doing nothing.... Average completion job time is 3 hours ..but its showing running...Tell me Issue.. ![alt text][1] [1]: /storage/temp/2589-error-job.jpg
job failure
error-job.jpg (8.7 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image
David Wimbush answered
How long has it been running (ie. is it over-running)? How do you know it's doing nothing? Perhaps it's taking longer than usual because the server is working harder than usual.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

rakeshsingh1983 avatar image rakeshsingh1983 commented ·
its showing running more than 12 hours..still showing running..average competition time is 3 hours..
0 Likes 0 ·
David Wimbush avatar image
David Wimbush answered
You could see if it's being blocked by something (unlikely but you want to make sure). Run sp_who2 and see if its process is being blocked by another (in the BlkBy column). You could check how hard the machine is working. It might just be working hard and therefore slow. You could look at what the job does. If it processes an input file, is the latest file much bigger than usual?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.