What should you do?

You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company.
You create a maintenance named JobA that is run manually by Domain.com users in the Sales department. A month later you become concerned that Sales department users may neglect running JobA and want determine when JobA was last run.
What should you do? (Each correct answer presents a complete solution. Choose two.)

You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company.
You create a maintenance named JobA that is run manually by Domain.com users in the Sales department. A month later you become concerned that Sales department users may neglect running JobA and want determine when JobA was last run.
What should you do? (Each correct answer presents a complete solution. Choose two.)

A.
Run the sp_monitor stored procedure.

B.
Run the sp_help_jobhistory stored procedure.

C.
Run the sp_help_jobactivity stored procedure.

D.
Run the sp_help_job stored procedure.

Explanation:
The sp_help_jobactivity and the sp_help_jobhistory stored procedures returns information about a job, including when the job was last run.
Incorrect Answers:
A: The sp_monitor stored procedure returns server activity statistics. It does not return information related to when a job was last run.
D: The sp_help_job stored procedure returns information about jobs used by SQL Server to perform automated activities. It does not return information related to when a manual job was last run.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: sp_monitor Microsoft SQL Server 2005 Books Online (2006), Index: sp_help_jobhistory Microsoft SQL Server 2005 Books Online (2006), Index: sp_help_jobactivity Microsoft SQL Server 2005 Books Online (2006), Index: sp_help_job



Leave a Reply 0

Your email address will not be published. Required fields are marked *