You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include implementing maintenance on a SQL Server 2005 database server named Certkiller -DB01.
At present there are certain jobs that run every Sunday whilst other jobs run at the start of every month. A Domain.com user named Amy Walsh is a member of the Finance department. You instruct her to schedule the jobs in the way that uses the minimum administrative effort.
What should Amy Walsh do?
A.
Amy Walsh needs to create a job schedule that runs once a day.
Then she can assign jobs to this job schedule.
Thereafter the jobs can be executed if the day is either a Sunday or the first day of the month.
B.
A job needs to be created for every task that runs daily.
Then Amy Walsh can use a Transact-SQL statement to check the date and day of the week.
Thereafter a code needs to be executed if the day is either a Sunday or the first day of the month.
C.
Amy Walsh needs to create a job schedule that runs every Sunday.
Then she can assign weekly tasks to this schedule.
She can then create a second schedule that runs on the first day of every month.
Thereafter she can assign monthly tasks to this schedule.
D.
Amy Walsh needs to create a job for every task that runs weekly on Sundays.
Thereafter she should add a second job schedule that runs the job on the first of the month.
Explanation:
You need 2 schedules or both tasks will be executed on Sundays and on the first day of the month. Creating a job schedule for every task that runs once a week instead of creating one schedule containing all the tasks would use more administrative effort than needed.