<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Scripts with tag
SQL Agent
Search for
any
content tagged
sql agent
Add a script
Items 1 to 10 of 10
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,477 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,650 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,621 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
2010/08/20
|
Source:
SQLServerCentral.com
|
Category:
reporting services (ssrs)
Rating:
|
Discuss
|
Briefcase
|
1,487 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,141 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,495 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
|
963 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,531 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,544 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,774 reads
Items 1 to 10 of 10
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
