An automatic job running via DBMS_JOB has failed. Knowing only that "it�

An automatic job running via DBMS_JOB has failed. Knowing
only that "it's failed", how do you approach troubleshooting
this issue?

Question Posted / narmada kumari

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", h..

Answer / braj123

>>First check the alert.log file for what reason the job
failed.
>>

Is This Answer Correct ?

0 Yes

0 No

More DB Administration Interview Questions

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

How would you determine what sessions are connected and what resources they are waiting for?

What is blocking and how would you troubleshoot it?

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

I lost one datafile i dont have backup how can you recover that???

What column differentiates the V$ views to the GV$ views and how?

What view would you use to look at the size of a data file?

what is logical system in sap basis

What are statistics, under what circumstances they go out of date, how do you update them?

suppose you want to audit specific activities on sensitive data. How can you achieve that?

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

how can you record information about current session?

For more DB Administration Interview Questions Click Here