Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag Job history Rss

Search for any content tagged job history

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 6 of 6   

Add empty first step for every job

This script adds empty first step for every job for easier job history viewing.  Read more...
By Alexander Sigachov 2015/12/28 | Source: | Category: job
Rating: (not yet rated) |  Discuss |   Briefcase | 1,616 reads

Split Function to break the Job History Message into a Table

Split Function for T-SQL Server to break the Job History Message into Table.  Read more...
By Ludwig Guevara 2012/03/22 | Source: | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,026 reads

Select the last error in the job selected

The job will send an HTML email with the latest error at specific job.  Read more...
By Ludwig Guevara 2012/03/15 | Source: | Category: sql jobs
Rating: (not yet rated) |  Discuss |   Briefcase | 864 reads

Clearing Change Log Entries

This script deletes the entries from table "change log entries" for a period specified by a parameter.  Read more...
By Spectacle 2010/01/19 | Source: | Category: agent jobs
Rating: |  Discuss |   Briefcase | 531 reads

Job failures

Script shows failed job steps 
By Vladimir Antovic 2008/10/14 | Source: | Category: job history
Rating: |  Discuss |   Briefcase | 853 reads

Display Job Schedule Description (SQL Server 2005)

The idea was taken from this script: Which did not work in SQL 2005 due to table changes on MSDB  Read more...
By Cowboy DBA 2013/05/08 | Source: | Category: maintenance and management
Rating: |  Discuss |   Briefcase | 5,461 reads
   Items 1 to 6 of 6