Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Job history Rss

   Items 1 to 8 of 8   
 

Monitoring job history using Reporting Services

Easily monitoring your SQL Agent job history using SSRS for concurrency, job lenght and job status.  Read more...
By Tomaz Kastrun 2013/09/05 | Source: SQLServerCentral.com | Category: job
Rating: |  Discuss |   Briefcase | 7,109 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,808 reads

Querying SQL Server Agent Job History Data

Often times we are tasked with having to programmatically come with a list of durations per SQL Server Agent Job to trend the run times and order the results by date. Unfortunately it's not always easy in the way the data is stored in the system tables in the MSDB database. This tip explains how to use the system tables to get the data into the correct format for dates and job durations.  Read more...
By Additional Articles 2013/01/02 | Source: MSSQLCity.com | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 3,157 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: 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,808 reads
   Items 1 to 8 of 8   
 
Tags
jobs (2)    
t-sql (2)    
generate job schedules (1)    
job (1)    
job activity (1)    
job schedule (1)    
maintenance and management (1)    
monitoring (1)    
reporting services (ssrs) (1)    
split function (1)    
sql agent (1)    
sql jobs (1)    
sql server agent (1)