Click here to Skip to main content
16,016,204 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
Why Developers need sql server agent
Posted
Updated 15-Oct-13 19:22pm
v2

A simple Google search can give you thousands of answer for your question.

TechNet:
SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs in SQL Server 2012.

SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database.

SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand. For example, if you want to back up all the company servers every weekday after hours, you can automate this task. Schedule the backup to run after 22:00 Monday through Friday; if the backup encounters a problem, SQL Server Agent can record the event and notify you.
WikiPedia:
SQL Server Agent is a component of Microsoft SQL Server which schedules jobs and handles other automated tasks. It runs as a Windows service so can start automatically when the system boots or it can be started manually. It is .

Typical system tasks performed include scheduling maintenance plans (such as backups), handling Reporting Services subscriptions and performing log shipping sub-tasks (backup, copy, restore & check). User tasks, such as scheduling some T-SQL or command line statement are also common.

SQLAgent has support for operators and alerts, so that administrators can be notified, e.g. by email.
Oreally:
If you'd like to automate some of your SQL server tasks, check out SQL Server Agent. With it you can schedule jobs, restart services, send email alerts, and perform other automation.
how-to-use-sql-server-agent/[^]
 
Share this answer
 
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900