SQL Server Jobs

SQL Server Agent Jobs – Displaying Status in an Application

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

Auto alert for SQL Agent jobs when they are enabled or disabled

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.

Checking SQL Server Agent jobs using Windows PowerShell

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?

Analyzing SQL Agent Job and Job Step History in SQL Server

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.

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

Database Mail and SQL Agent Mail setup by using a script

In this tip I provide a script with a few parameters that need to be setup to configure and turn on both of these features.

Monitoring SQL Server Agent with Powershell

This article introduces the reader to Powershell. The application that it demonstrates is one that monitors SQL Server Agent to make sure it is running.

Adding a UI to the Standalone SQL Agent

In a recent blog post, SQL Server expert Denny Cherry discusses adding a user interface to his Standalone SQL Agent, a replacement for the SQL Server Agent service.

Job Report on SQL 2005

get a job report on a server from T-SQL