SQL Administrator Question:
Download Job Interview Questions and Answers PDF
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.
Download SQL Administrator Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Please explain why would you call Update Statistics? | Tell us what are the recovery models for a database? |