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:07 am

    #1443590

    george sibbald (2/7/2012)

    people may also want to look at sp_help_job and xp_sqlagent_enum_jobs

    Yes, especially when you are out of permissions to directly query sys tables.