SQL Server Database Administrator Question:

Download Job Interview Questions and Answers PDF

Why would you use SQL Agent?

SQL Server DB Administrator Interview Question
SQL Server DB Administrator Interview Question

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 Server DB Administrator Interview Questions And Answers PDF

Previous QuestionNext Question
How do you test proper TCP/IP configuration Windows machine?How to define testing of network layers?