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



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

Post New Answer

More DB Administration Interview Questions

Explain what partitioning is and what its benefit is.

2 Answers  


How do you resize a data file?

2 Answers  


Which environment variables are absolutely critical in order to run the OUI?

2 Answers  


What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  


which background process invoke at the time of upgradation tell me???

0 Answers   iGate,






What types of replication are supported in sql server? : sql server DBA

0 Answers  


Give the reasoning behind using an index.

2 Answers  


What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  


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

1 Answers  


You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  


Name three advisory statistics you can collect.

1 Answers  


Categories