question

shamim007 avatar image
shamim007 asked

suspended jobs are not found in job activity monitor

after i ran sp_whoisactive i found agent job is suspended SQLAgent - TSQL JobStep (Job 0xB1002DE72BDC4949941257E8B774ECAB : Step 1) ,wait info (8ms)PAGEIOLATCH_SH:NetDB:3(*),,CPU 699,870 ,i try to look up job activity monitor but could not find the job.i am confused now what to do ? should i kill the job?
jobsagentper
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
Wilfred van Dijk avatar image
Wilfred van Dijk answered
A job can have several statuses, but not suspended. It's probably in a "RUNNING" state, because a suspended task means it's still active (hence the result in sp_whoisactive). I suggest to implement a job monitor script which detects long running jobs. A lot of these scripts can be found on sqlservercentral
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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.