Post reply

How to check the status of a SQL job?

  • November 11, 2008 at 5:06 am

    #195933

    Hi,

    I need to check whether a specific job is currently running or not. how can i achieve this using SQL commands?

  • November 11, 2008 at 6:18 am

    #896897

    You can check the system tables in the msdb database - sysjobactivity and sysjobhistory...

    you should be able to get information on current job activity and status from sysjobactivity and information on executed jobs from sysjobhistory...

  • November 11, 2008 at 8:33 am

    #896976

    You should use the system stored procedures (sp_help_job). Microsoft can (and does) make schema changes to MSDB without much notice.

  • November 11, 2008 at 8:35 am

    #896978

    sp_help_job is what I'd use as well.

  • November 12, 2008 at 8:41 am

    #897582

    check out xp_sqlagent_enum_jobs as well.

    ---------------------------------------------------------------------

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply