Home > DeveloperSection > Interviews > What is the function of SQL Server Agent Windows service?

Posted on    October-12-2014 10:58 PM

 MSSQL Server Database  MSSQL Server 
 1 Answer(s)
  914  View(s)
Rate this:

Kamlakar Singh
Kamlakar Singh

Total Post:80

Posted on    October-12-2014 10:58 PM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick