SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs. SQL Server Agent uses SQL Server to store job information. Jobs contain one or…

The correct answer is A. All of these. SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand. For example, if you want to back up all the company servers every weekday after hours, you can automate this task

Design and implement an optimized data maintenance solution

Question

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs. SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Which of the following is a component of SQL Server Agent?

Options

AAll of these
BJobs ?work to be done
CSchedules ?when job is executed
DAlerts ?notification when event occurs

How the community answered

(34 responses)

A
74% (25)
B
3% (1)
C
6% (2)
D
18% (6)

Explanation

SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand. For example, if you want to back up all the company servers every weekday after hours, you can automate this task

Topics

#SQL Server Agent#jobs#schedules#alerts

Community Discussion

No community discussion yet for this question.

Full 70-450 Practice