Script to delete all SQL Agent jobs owned by a user.  Read more...

 A colleague pointed out a site that collects a lot of job posting data and exposes graphs - so I've taken...  Read more...

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...

This article shows ways of getting feedback to your users when running a SQL Server agent job from an ASP.NET page  Read more...

Keeping track of the jobs you have running across all your servers can be a challenge these days with fewer and fewer employees. New author Sivakumar Mahalingam brings us an article that shows one way to accomplish this task.  Read more...

It is often the case in large DBA teams where multiple DBAs can administer the same SQL Servers and it is not apparent to one DBA the importance of some of the jobs to another DBA. In this tip I show how you can be alerted of these changes.  Read more...

Everyone has an opinion on the best advice to give an IT person who is unemployed and wants to get back into paid work. Phil Factor outlines what he would advise.  Read more...

This article will show you how you can execute a SQL job with one click, allowing anyone to do this. Author Divya Agrawal shows a technique to let other users run jobs that do things such as perform a backup with a batch file.  Read more...

Here is a stored procedure that start a job, and then waits until the jobs is finished  Read more...

You may have a number of jobs scheduled and often there is the need to analyze the data to see which jobs are taking a long time or which job steps are taking a long time. As you add more jobs and overhead to the server these times become even more critical and analyzing the data is key.  Read more...

Similar to many other Job History scripts, but unique in that it has a timeline.  Read more...

This script returns the information of all SQL Jobs that are running on the server with the latest status.  Read more...

Checks if a sql server job ran successfully in the last xx minutes.   Read more...

get a job report on a server from T-SQL  Read more...

Here's an article from Rudy Panigas on how to more effectively manage multiple servers.  Read more...

Read more...

Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them  Read more...

SQL Agent is one of the handiest subsystems in SQL Server. This video shows how you can schedule a one-time job to handle something without you being there.  Read more...

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server  Read more...

In my previous article Scheduling Jobs in SQL Server Express we saw how to make simple job scheduling in SQL Server 2005 Express work. We limited the scheduling to one time or daily repeats. Sometimes this isn't enough. In this article we'll take a look at how to make a scheduling solution based on Service Broker worthy of the SQL Server Agent itself.  Read more...

Keeping track of the jobs you have running across all your servers can be a challenge these days with fewer and fewer employees. New author Sivakumar Mahalingam brings us an article that shows one way to accomplish this task.  Read more...

This article shows ways of getting feedback to your users when running a SQL Server agent job from an ASP.NET page  Read more...

Here's an article from Rudy Panigas on how to more effectively manage multiple servers.  Read more...