SQL Administrator Question:
Tell me why would you use SQL Agent?
Answer:
SQL Agent is the job scheduling mechanism in SQL Server. Jobs can be scheduled to run at a set time or when a specific event occurs. Jobs can also be executed on demand. SQL Agent is most often used to schedule administrative jobs such as backups.
| Previous Question | Next Question |
| Please explain why would you call Update Statistics? | Tell us what are the recovery models for a database? |