Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag SQL Server Agent Rss

Search for any content tagged sql server agent

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 6 of 6   
 

Add empty first step for every job

This script adds empty first step for every job for easier job history viewing.  Read more...
By Alexander Sigachov 2015/12/28 | Source: SQLServerCentral.com | Category: job
Rating: (not yet rated) |  Discuss |   Briefcase | 1,610 reads

Long Running Jobs Monitor

Script to be executed every 60 minutes as a job to determine long running jobs.  Read more...
By Gregory Ferdinandsen 2015/04/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,588 reads

Scheduling Jobs for Random / Multiple Dates

I needed to run an ssis package / job on many dates that were not consistent and initially started creating dozens of job schedules before coming up with this idea...  Read more...
By Charles Fuller 2011/01/13 | Source: SQLServerCentral.com | Category: agent jobs
Rating: |  Discuss |   Briefcase | 1,015 reads

SQL Server Agent Schedule Decoder

This script will break job schedules down into a readable format (msdb.dbo.sysschedules)  Read more...
By Michael Abair 2010/01/06 | Source: SQLServerCentral.com | Category: agent jobs
Rating: |  Discuss |   Briefcase | 1,892 reads

Delete SQL Agent Jobs owned by specific user

Script to delete all SQL Agent jobs owned by a user.  Read more...
By Damien Alvarado 2009/09/29 | Source: SQLServerCentral.com | Category: sql server agent
Rating: (not yet rated) |  Discuss |   Briefcase | 623 reads

Report upcoming SQL Jobs

Which jobs are ready to run the next 24 hours / this weekend?  Read more...
By Wilfred van Dijk 2008/12/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 434 reads
   Items 1 to 6 of 6