Monday, February 25, 2013

Get the List of Failed Jobs

Here is the simple script for finding all failed jobs in the server. For Daily monitoring this script is very handy for all DBA's who all are working on multi server administration.

use msdb
GO
SELECT name,
date_created,
last_outcome_message,
last_run_date,
last_run_duration
FROM msdb.dbo.sysjobs A, msdb.dbo.sysjobservers B
WHERE A.job_id = B.job_id AND B.last_run_outcome = 0
GO



Failed SQL Server Agent Jobs, Set Job Step Success or Failure Flow, Querying SQL Server Agent Job Information, How to obtain failed jobs from sql server agent through script , Script to Show All Failed Jobs in Specified Period, Find failed SQL Agent jobs using Transact-SQL script, Get failed SQL Server agent job, Getting failed jobs in the last hour, How to get the failed jobs list in sql server 2012, How to get the failed jobs list in sql server 2008 R2, List Failed Jobs for MSSQL 2005, 

0 comments:

Post a Comment