3 Oct, 2022
T-SQL query to check failed SQL Agent Jobs in the Last 24 Hour 0 (0)
MSSQL, T-SQL Scripts , ,

Below query can be used to check SQL Agent failed jobs in last 24 hours. This query can be used in the monitoring script to find out failed job in SQL server agent.

SELECT sj.[name] AS "Failed Job Name", jh.run_date,jh.[message]
… Read the rest