Job Status

  • How to check the Status of the Job whether its running or not?

  • You can check the job activity monitor which will display all the details..

    [font="Verdana"]- Deepak[/font]

  • Hi,

    Also you can use the following sp

    EXEC msdb..sp_help_job

    and check current_execution_status

    Regards,

    Ahmed

  • 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

  • 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.

  • 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