How do you troubleshoot errors in a sql server agent job? : sql server DBA



How do you troubleshoot errors in a sql server agent job? : sql server DBA..

Answer / Payal Srivastava

Troubleshooting errors in a SQL Server Agent job can be done by checking the Job History, Reports, and Alerts. Additionally, reviewing the SQL Server Agent error log and system tables can provide more detailed information about the error. Lastly, monitoring the job step history and modifying the job steps if necessary can help resolve the issue.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

what do you understand by flashback feature of oracle?

1 Answers   Oracle,


what is meant by gateway

1 Answers   IBM,


Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,


i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,


what is the differnce between process and thread ?

1 Answers   IBM,


Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  


What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,


What command would you use to encrypt a PL/SQL application?

1 Answers  


what is the diffrence between core dba and apps dba?

1 Answers   Cap Gemini,


Name three advisory statistics you can collect.

1 Answers  


the process of adding a cpu in sql server is called..?

2 Answers   TCS,


one datafile is lost in standy side how can you recover that??

2 Answers  


Categories