SQL Administrator Question:

Tell me why would you use SQL Agent?

Tweet Share WhatsApp

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