Question 18

Answer D is correct. sp_help_job is the only procedure that provides information on historical executions of tasks. sp_help_job_schedule and sp_help_schedule only give you the time for the next execution, not anything that previously occurred.

For more information, see the following sources:

• Chapter 6, "Database Maintenance"

• SQL Server 2005 Books Online: "SQL Server Language Reference, Transact-SQL Reference, System Stored Procedures (Transact-SQL), SQL Server Agent Stored Procedures (Transact-SQL)"

• "System Stored Procedures," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_00_519s.asp