SQL Server Agent

Hi Vipendra,

SQL Server Agent is a Microsoft Windows service that allows you to automate some administrative tasks. SQL Server Agent runs jobs, monitors SQL Server, and processes alerts. The SQL Server Agent service must be running before local or multiserver administrative jobs can run automatically.


Please refer the below link

http://msdn.microsoft.com/en-us/library/ms189237.aspx

http://msdn.microsoft.com/en-us/library/ms189089%28v=sql.105%29.aspx

http://www.quackit.com/sql_server/tutorial/sql_server_agent.cfm

Thanks