SQL Server Agent

Question

Hi friends I want to know concept of SQL Server Agent ? Thank you.

Satyapriya Nayak · Answer

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