Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 5 of 5   
 

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: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,006 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: SQLServerCentral.com | Category: sql jobs
Rating: (not yet rated) |  Discuss |   Briefcase | 842 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: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 523 reads

Job failures

Script shows failed job steps  Read more...
By Vladimir Antovic 2008/10/14 | Source: SQLServerCentral.com | Category: job history
Rating: |  Discuss |   Briefcase | 763 reads

Display Job Schedule Description (SQL Server 2005)

The idea was taken from this script: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/ Which did not work in SQL 2005 due to table changes on MSDB  Read more...
By Cowboy DBA 2013/05/08 | Source: SQLServerCentral.com | Category: maintenance and management
Rating: |  Discuss |   Briefcase | 4,811 reads
   Items 1 to 5 of 5