SQL Administrator Question:
Download Questions 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 QuestionNext Question
Please explain why would you call Update Statistics?Tell us what are the recovery models for a database?