SQLServerCentral: Scripts tagged Job history

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 | 959 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 | 788 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 | 504 reads

Job failures

Script shows failed job steps Read more...

By Vladimir Antovic 2013/05/19 | Source: SQLServerCentral.com | Category: job history

Rating:

|

Discuss |

Briefcase | 666 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 | 3,727 reads

Scripts with tag Job history

Add a script

Split Function to break the Job History Message into a Table

Select the last error in the job selected

Clearing Change Log Entries

Job failures

Display Job Schedule Description (SQL Server 2005)