SQLServerCentral.com Scripts tagged SQL Agent

Check SQL Job timings

Tue, 11 Sep 2012 06:00:00 UT

This script is useful to check how long jobs have been running.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

SQL Agent Jobs Summary

Thu, 29 Dec 2011 07:00:00 UT

The following script can be used to determine the list of enabled SQL Agent Jobs, their start time, average run duration and next run date.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Get an email notification of the failed job step detail

Thu, 17 Feb 2011 07:00:00 UT

This trigger will notify the existing email operator of the job with detailed job step information.

retrieve SSRS report schedule info through SQL

Fri, 20 Aug 2010 06:00:00 UT

Grabs information about what reports in SSRS are scheduled, when are they due to be sent out, report parameters and any errors in the last run etc.

View to obtain Failed Jobs from SQL Server Agent

Tue, 30 Mar 2010 06:00:00 UT

With this view you can obtain last failed job steps without using visual interface.

Script all the jobs on a SQL server 2005 and apply them in SQL 2008

Fri, 18 Sep 2009 06:00:00 UT

The script will produce a Drop/Create script for all the jobs existing on the server. Instead of scripting them individually. The output script will also have schedules scripted out

Create Your Own Batch Runs Composed Of Existing Jobs

Tue, 02 Jun 2009 06:00:00 UT

Here is a stored procedure that start a job, and then waits until the jobs is finished

What SQL JOb's are running on 2005 Server

Fri, 01 May 2009 06:00:00 UT

This script returns the information of all SQL Jobs that are running on the server with the latest status.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Job History with Timeline

Tue, 01 Jun 2010 06:00:00 UT

Similar to many other Job History scripts, but unique in that it has a timeline.

Job Report on SQL 2005

Fri, 10 Apr 2009 06:00:00 UT

get a job report on a server from T-SQL