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

Scripts with tag Job Rss

Search for any content tagged job

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   
 

Create notifications for failed jobs with one easy script

Here an easy way to setup alerts for all sql agent jobs. Typically I use this to send an email alert when a job fails. I always setup a group email address rather than individuals to make this a one-time setup.  Read more...
By Patrick Akhamie 2014/05/12 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,420 reads

Job and Step Run Checker

A script that shows you jobs and steps that have succeded or failed recently. (basically, a T-SQL version of your SSMS Job Activity Monitor)  Read more...
By Orestes Zoupanos 2013/07/05 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,093 reads

SQL Job Timeline (Graphical)

This script generates a graphical timeline of all SQL jobs with a variable zoom level  Read more...
By Theo Ekelmans 2013/01/29 | Source: SQLServerCentral.com | Category: job
Rating: |  Discuss |   Briefcase | 2,384 reads

Show Job Run Snapshot

Show all job history between two dates. This is much easier than trying to navigate the job history log file viewer.  Read more...
By Monte Kottman 2012/10/19 | Source: SQLServerCentral.com | Category: job
Rating: |  Discuss |   Briefcase | 1,056 reads

Check SQL Agent Job Status

Useful for when you have something depending on the outcome of a job.  Read more...
By MyDoggieJessie 2012/01/05 | Source: SQLServerCentral.com | Category: agent
Rating: |  Discuss |   Briefcase | 1,862 reads

UP_COMPACTA_COPIA

I have several problems with my corporate network and therefore need to do all my backups locally, and to make matters worse, still use SQL Server 2005.   Read more...
By Lucas Souza 2011/10/17 | Source: SQLServerCentral.com | Category: job
Rating: |  Discuss |   Briefcase | 416 reads
   Items 1 to 6 of 6