SQL Server Agent is at the heart of any live database system. The Agent has a number of uses which aren't always obvious, and so a knowledge of the system is always useful, to developers as well as DBAs. Richard Waymire provides a simple explanation of its many uses.  Read more...

Read more...

This article has a T-SQL function to detect the SQL Agent job state.  Read more...

Read more...

This trigger will notify the existing email operator of the job with detailed job step information.  Read more...

SQL Server Agent jobs are made up of a series of one or more Job Steps. A job step is assigned to a specific job subsystem, which identifies the kind of work the job step is going to perform. Each job step runs in a separate security context, although each job also has an owner that determines who can modify the job.  Read more...

In a previous tip, the tip reviewed several steps for a better and improved environment for scheduled jobs. I am totally convinced with the recommendations and want to implement these for my scheduled jobs. To make this easier, I want to create a template so I can produce a suitable and reliable way of updates for my production server. In this tip I provide a step by step exercise to perform on a test server to prepare the customized and tested scripts to run on the production server.  Read more...

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

The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.  Read more...

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

Proxy accounts are a useful tool to enable teams to work independently allow users who do not have administrative access to SQL Server to run jobs.  Read more...

The usefulness and utility of the SQL Server Agent cannot be overstated. Oracle Database supports the automatic starting of an instance, so whatever is associated with the Oracle instance can also be started along with the instance. The same holds true with the SQL Server instance and its agent service.  Read more...

With this view you can obtain last failed job steps without using visual interface.  Read more...

In this article, learn how to use the SQL Server agent proxy to run an SSIS Package under whatever account you choose.  Read more...

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

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

Checking for SQL Server Agent jobs and their status is part of your daily task as a DBA. How do we use Windows PowerShell to check for SQL Server Agent jobs?  Read more...

Operators in SQL Server work hand in hand to ensure that alerts are sent to the proper person. MVP Andy Warren shows how to set these up in this SQL School video.  Read more...