You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) instance.
The following events must occur at 2:00 on every Sunday:
A data-driven subscription for the Human Resources report must write to several file shares.
The execution of the Sales report must expire.
The history of the Manufacturing report must include a new state of the data.
You need to configure the package so that the events occur and are exposed for a single-step batch job.
What should you do?
A.
Use a shared schedule and start the SQL Agent service on the SSRS database server.
B.
Use a shared schedule and disable the SQL Agent service on the SSRS database server.
C.
Use a report-specific schedule for each task and start the SQL Agent service on the SSRS database server.
D.
Use a report-specific schedule for each task and disable the SQL Agent service on the SSRS database server.