SQLServerCentral.com Scripts tagged Agent

SQL Start up Script

Tue, 25 Sep 2012 06:00:00 UT

This is a script that I run when SQL starts to notify me via email that a server has restarted as well as the location of the server.

Check SQL Agent Job Status

Thu, 05 Jan 2012 07:00:00 UT

Useful for when you have something depending on the outcome of a job.

Want to work faster with SQL Server?
If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download the SQL Toolbelt here.

Check if a sql server agent job ran

Wed, 29 Apr 2009 06:00:00 UT

Checks if a sql server job ran successfully in the last xx minutes.

sp_update_job for all jobs.

Thu, 23 Oct 2008 06:00:00 UT

Runs a custom sp_update_job statement against every job on the server.