SQL Database Concepts Question:
Explain what is the function of SQL Server Agent Windows service?
Answer:
- 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.
- This service is very useful in determining why a particular job did not run as intended.
| Previous Question | Next Question |
| Tell me what do you understand by a view? What does the WITH CHECK OPTION clause for a view do? | Can you please differentiate between a primary key and a unique key? |