SQLServerCentral.com Articles tagged SQL Agent

Providing SQL Agent Job Log Data for Developers

Tue, 29 Jan 2013 07:00:00 UT

As a production Database Administrator, I do not want to give Developers direct access to the SQL Server Agent job log especially for servers in the DMZ. Another problem we have is that when there is a lot of log data for a job, the default job log doesn't contain the full log detail and that makes it harder to troubleshoot. Most of all, we are trying not to use a different code set for deployment based on the environment. Basically we want to use the same methods to deploy our jobs to Development, Test and Production.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Be Careful Using LiteSpeed Extended Stored Procedures With SQL Agent

Tue, 04 Sep 2012 09:36:18 UT

It’s uncommon that a SQL Server DBA needs to create a customized backup and restore routine for an application using combination of LiteSpeed extended stored procedures. However, you should be really careful when you are implementing such a solution.

Working with SQL Agent Durations

Thu, 23 Aug 2012 06:00:00 UT

SQL Agent stores duration in HHMMSS format - not always useful. Discover how to use Powershell, some basic math, and T-SQL to tame these unruly values.

TSQL function to detect SQL Agent job state

Tue, 07 Feb 2012 07:00:00 UT

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

Stairway to SQL Server Agent - Level 2: Job Steps and Subsystems

Thu, 17 Feb 2011 07:00:00 UT

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.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

SQL Server Agent Job Management Scripts

Thu, 18 Nov 2010 07:00:00 UT

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.

SSIS Package to Script All SQL Server Jobs to Individual Files

Tue, 06 Jul 2010 06:00:00 UT

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

Running SQL Server Jobs using a Proxy Account

Mon, 31 May 2010 06:00:00 UT

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.

SQL Server Management Features vs Oracle Database Management Features

Thu, 06 May 2010 06:00:00 UT

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.

Run an SSIS Package Under a Different Account

Thu, 25 Mar 2010 06:00:00 UT

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

SQL Server Agent Jobs – Displaying Status in an Application

Wed, 16 Sep 2009 06:00:00 UT

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

Thu, 13 Aug 2009 06:00:00 UT

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

Tue, 28 Jul 2009 06:00:00 UT

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?

Configuring SQL Agent Operators - SQL School Video

Thu, 02 Jul 2009 06:00:00 UT

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.

Configuring Auto-Retry on SQL Server Agent

Mon, 01 Jun 2009 06:00:00 UT

The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to use it. I hope to clarify in which circumstances an auto-retry works best and when not to use it also. The (disclaimer!) point is that every job has its own constraints, requirements, and has to be evaluated individually for whether an auto-retry will work. I will try and keep this summary short and crisp, but still with enough detail to understand auto retry best.

Analyzing SQL Agent Job and Job Step History in SQL Server

Fri, 29 May 2009 06:00:00 UT

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.

Database Mail and SQL Agent Mail setup by using a script

Mon, 11 May 2009 06:00:00 UT

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

Tue, 31 Mar 2009 06:00:00 UT

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

Tue, 17 Mar 2009 06:00:00 UT

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.

Managing many SQL Servers?

Thu, 15 Jan 2009 07:00:00 UT

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

Proxy Accounts in SQL Server

Tue, 30 Dec 2008 07:00:00 UT

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

Creating One-Time Jobs - SQL School Video

Tue, 23 Dec 2008 07:00:00 UT

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.

How do I assign permissions to users to see SQL Agent Jobs?

Tue, 16 Dec 2008 07:00:00 UT

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

Scheduling Jobs in SQL Server Express - Part 2

Tue, 09 Dec 2008 07:00:00 UT

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.

Generate SQL Agent Job Schedule Report

Fri, 21 Nov 2008 07:00:00 UT

I am trying to come up with a list of Job Schedules so I can make sure that my Jobs are staggered. Is there a way to query the system tables so I do not have to manually keep track of the schedules?

Use Operations Manager to Monitor Your SQL Agent Jobs

Mon, 08 Sep 2008 06:00:00 UT

Monitoring your SQL Server Agent jobs is important to ensuring that all of the automation you have created on your server is working correctly. Thomas LaRock brings us another article on Operations Manager and its integration with SQL Server.