DBA > Job Interview Questions > Microsoft SQL Server FAQs

Which table would you query in your report to ge

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Which table would you query in your report to get logging information about a job step?

You have a notification set up in SQL Server 2005 to let you know when a job fails. However you would like more details about the step that failed. Which table would you query in your report to get logging information about a job step?

Answer: msdb.dbo.sysjobstepslogs
Explanation: The MSDB.dbo.sysjobstepslogs table contains information about each step that is configured to log its data. You can query this table for information about the job.

(Continued on next question...)

Other Job Interview Questions