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

• If you set RETENTION = ON in your SQL Server 2005 Service Broker queue, what messages are retained?
• Which of the following is an invalid file name for a database file?
• Can you use Full-text search to index this column?
• What does a report model provide in SQL Server 2005 Reporting Services?
• You want to create a covering index for this query on your SQL Server 2005 database ...
• What method would you call to create this key?
• What does a return value of -1 mean from the function XACT_STATE() in SQL Server 2005?
• SELECT USER_NAME() -- Returns Andy
• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• You want to be sure your database server if properly secured. You have two instances, a default instance and a named instance installed. Which ports do you need to open?
• More...