Monitor State of SQL Server Agent Jobs

Version 1

    This template will allow you to monitor the state of your SQL Server Agent Jobs. You will need to specify the agent job name within the body of the SQL Query. You will need the proper credentials to execute against the db. Also, specify SQL Server Instance and DB name.

     

    The query is checking the last_run_outcome for the job specified. Statistical values will return the following based on the outcome of the job the last time it ran.

    0 = Failed

    1= Succeeded

    3 = Canceled

    5 = Unknown