Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 17 of 17   
 

Job Step Log Output file path

If you have a requirement to carefully have the output file against each sql agent job step, you can use this script. If incase, there are many sql agent jobs and by any reason if any of the step does not have proper o/p file, this script can automatically create the o/p file.  Read more...
By S M 2016/05/20 | Source: SQLServerCentral.com | Category: agent jobs
Rating: |  Discuss |   Briefcase | 71 reads

SQL Agent job to show SQL Server service details upon agent restart

To show SQL Server and physical server details upon instance restart so that we have visibility of unexpected issues with servers and services.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 514 reads

SQL server Service, Account, Trace Flag info

This script outputs sql server service, start type, status, Service Account, installation location, start up time, uptime of sql server related services along with startup trace flags.   Read more...
By Kin Shah 2015/12/17 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 941 reads

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 2016/04/14 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 2,453 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,797 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,177 reads

Scripting SQL Agents Jobs using Powershell

The script helps to Scripting SQL Agents Jobs using Powershell automatically by scheduling as a job.  Read more...
By Saranya Venugopal 2015/02/04 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,801 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,709 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,992 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,867 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,494 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: agent jobs
Rating: |  Discuss |   Briefcase | 2,230 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: agent jobs
Rating: |  Discuss |   Briefcase | 2,937 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 | 1,015 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: agent jobs
Rating: |  Discuss |   Briefcase | 1,582 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: agent jobs
Rating: |  Discuss |   Briefcase | 2,924 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,888 reads
   Items 1 to 17 of 17