I have a scheduled a job in DBMS jobs (not DBMS scheduler). I can see the job has failed in weekends. I want to see the log file with failure reason. Where i can i find this?
Any suggestions please?
Thanks in advance.
For DBMS_SCHEDULER (as noted by Frank Schmitt) try this:
SELECT *
FROM DBA_SCHEDULER_JOB_RUN_DETAILS
ORDER BY LOG_DATE DESC;
and then look in your bdump folder, for the trace files.
For DBMS_JOB you can view your alert log file:
SELECT VALUE
FROM V$PARAMETER
WHERE NAME = 'background_dump_dest';
or
SELECT VALUE
FROM V$SPPARAMETER
WHERE NAME = 'background_dump_dest';
The alert log file has a name like "alert_orcl.log", if your database name is the default "orcl".