Thursday, March 10, 2011

Stairway to SQL Server Agent: Step 1: Setup and Overview


We all come across a situation where we need to schedule something & run the process in background automatically in database itself.

The tool that we can use to achieve this task is SQL SERVER AGENT.

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.

In this article Richard explains following things:
  • SQL Server Agent Setup and Overview
  • Getting SQL Server Agent Running
  • Setting the Agent to Auto-start with SQL Server
  • Creating your first Job

Click here to read full article.
Happy Learning




No comments: