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

Scripts with tag SQL Agent Rss

Search for any content tagged sql 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 13 of 13   
 

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,536 reads

List long running SQL Agent Jobs

List long running SQL Agent jobs and email out as HTML.  Read more...
By Neil Bryan 2013/10/07 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,578 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,109 reads

Check SQL Job timings

This script is useful to check how long jobs have been running.  Read more...
By Shishir Tewari 2012/09/11 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,654 reads

SQL Agent Jobs Summary

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.  Read more...
By Smitha Reddy 2011/12/29 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,860 reads

Get an email notification of the failed job step detail

This trigger will notify the existing email operator of the job with detailed job step information.  Read more...
By Gokhan Varol 2011/02/17 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 2,777 reads

retrieve SSRS report schedule info through SQL

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.  Read more...
By Ibrahim Naji 2014/02/21 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 2,404 reads

View to obtain Failed Jobs from SQL Server Agent

With this view you can obtain last failed job steps without using visual interface.  Read more...
By thor the viking 2010/03/30 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 2,197 reads

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

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  Read more...
By Amit Mathur 2009/09/18 | Source: SQLServerCentral.com | Category: generate jobs scipts
Rating: |  Discuss |   Briefcase | 2,637 reads

Create Your Own Batch Runs Composed Of Existing Jobs

Here is a stored procedure that start a job, and then waits until the jobs is finished  Read more...
By John van Beek 2009/06/02 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 993 reads

What SQL JOb's are running on 2005 Server

This script returns the information of all SQL Jobs that are running on the server with the latest status.  Read more...
By Sreedhar Kantae 2009/05/01 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 1,558 reads

Job History with Timeline

Similar to many other Job History scripts, but unique in that it has a timeline.  Read more...
By webtekkie 2010/06/01 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 2,703 reads

Job Report on SQL 2005

get a job report on a server from T-SQL  Read more...
By Bernabe Diaz 2009/04/10 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,848 reads
   Items 1 to 13 of 13