May 14, 2008 at 10:44 pm
How to check the Status of the Job whether its running or not?
May 15, 2008 at 12:13 am
You can check the job activity monitor which will display all the details..
[font="Verdana"]- Deepak[/font]
May 16, 2008 at 5:29 am
Hi,
Also you can use the following sp
EXEC msdb..sp_help_job
and check current_execution_status
Regards,
Ahmed
May 16, 2008 at 6:02 am
Ideal way of checking the job status is using the Activity Monitor because with Job Activity Monitory you can do the following...
- Create and Apply Filter for all executing jobs.
- Create and Apply Filter for all failed jobs
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 16, 2008 at 8:11 am
Using exec msdb..sp_help_job will return an output with a column indicating the current execution status, last run outcome etc etc, which needs to be interprated to know the meaning.
On the othe hand, the activity monitor will visually show you if the job is running, the step being ran, or even if it has failed and the step that failed. To me, this best serves the purpose more than using the alternative, unless you need to do more with the outcome.
May 16, 2008 at 8:31 am
Hi,
You are right. Unfortunately as 2000 dba I used to use this old sp.
Regards
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply