Page 1 of 1

What is the function of SQL Server Agent Windows service?

Posted: Wed Aug 19, 2015 11:29 am
by soniya roy
What is the function of SQL Server Agent Windows service?

Re: What is the function of SQL Server Agent Windows service?

Posted: Wed Aug 19, 2015 11:58 am
by kanishka khurana
It is a Windows service which handles the tasks scheduled within the SQL Server environment. These tasks are also called as job and are stored with in SQL server. The jobs may run through a trigger, a predefined schedule or on demand.
- This service is very useful in determining why a particular job did not run as intended.