Home Forums Article Discussions Article Discussions by Author Discuss content posted by Bret Lowery TSQL function to detect SQL Agent job state RE: TSQL function to detect SQL Agent job state

  • February 7, 2012 at 2:32 am

    #1443596

    Already mentioned SP_HELP_JOB with the parameters but also worth looking at :

    SP_HELP_JOBACTIVITY

    SP_HELP_JOBHISTORY

    🙂

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk