SQL Server Agent allows you to schedule jobs to perform any number of steps from backing up databases to running SQL scripts. Which of the following is the odd one out with regard to scheduling a…

The correct answer is A. Jobs can be run at random times. Jobs cannot be run on a random basis, you need to choose a specific trigger such as date and time, or CPU utilization.

Design and implement an optimized data maintenance solution

Question

SQL Server Agent allows you to schedule jobs to perform any number of steps from backing up databases to running SQL scripts. Which of the following is the odd one out with regard to scheduling a job through SQL Server Agent?

Options

AJobs can be run at random times
BJobs can be scheduled on a recurring basis
CJobs can be run once at a specific date and time
DJobs can be run when CPU utilization is idle

How the community answered

(16 responses)

A
69% (11)
B
6% (1)
C
19% (3)
D
6% (1)

Explanation

Jobs cannot be run on a random basis, you need to choose a specific trigger such as date and time, or CPU utilization.

Topics

#SQL Server Agent#job scheduling#automated tasks#scheduling options

Community Discussion

No community discussion yet for this question.

Full 70-450 Practice