Post reply

Job Status

  • May 14, 2008 at 10:44 pm

    #123907

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

  • May 15, 2008 at 12:13 am

    #815649

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

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

  • May 16, 2008 at 5:29 am

    #816367

    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

    #816393

    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

    #816516

    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

    #816532

    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