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