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




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net