Script to Show All Failed Jobs in Specified Period

By Janine Bocciardi, 2002/01/01

Total article views: 1136 | Views in the last 30 days: 56

Rate this |

Join the discussion |

Briefcase

This script will allow you to create a stored procedure that will check a server for any jobs that have failed in a specified number of days. It has proven valuable to me, since I have servers with lots of jobs that run frequently; I got tired of checking the history of each job to look for past failures. Keep in mind that this will only find job information that's currently in your msdb database; if your "Job History Rows per Job" or "Job History Log Size" parameters (in SQL Agent properties) are set so that the job history information is truncated too often, they may have to be changed.

By Janine Bocciardi, 2002/01/01

Total article views: 1136 | Views in the last 30 days: 56

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

Database Growth Monitor

By Brian Knight | Category: Miscellaneous

| 2,929 reads

The Log Watcher

By pochinej | Category: Miscellaneous

| 2,102 reads

Reset Identity Columns for Tables Using Them

By Chris Kempster | Category: Miscellaneous

| 475 reads

Calculate point in time DB Hit Ratios

By Chris Kempster | Category: Miscellaneous

| 678 reads

Like this? Try these...

Alert Procedure for Long-Running Job

By Janine Bocciardi | Category: Lock and Connection Management

| 1,480 reads

Send notifications on job STEP failures (trigger)

By spongemagnet | Category: Miscellaneous

| 1,581 reads

Stored Procedure to get Job History (with Steps)

By Andy Brown | Category: Miscellaneous

| 482 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com