Oracle PL/SQL Programming: A Developer's Workbook

Intermediate

25-24.	How does the job scheduler handle a job that terminates abnormally?
25-25.	Put the following steps of the SNP execution process in order: Start database session with job owner’s username. Execute PL/SQL mentioned in “what” parameter. If there are no errors, update next_date. If block fails, increment failures number, and set next execution date to one minute later if it’s the first failure, double interval otherwise. Calculate next execution date using interval’s formula. Alter session NLS settings to match those settings that were in effect when the job was originally submitted.
25-26.	How do you capture the error message associated with a job failure?
25-27.	How can you check to see if a job is currently running?
25-28.	How can you check to see how long a currently running job has been executing?
25-29.	What date functions can you use inside the interval string?
25-30.	What interval value can you use to execute a job every hour?
25-31.	What interval value can you use to execute a job every minute?
25-32.	What interval value can you use to execute a job every second?
25-33.	What interval value can you use to execute a job every day at 11 A.M.?
25-34.	What interval value can you use to execute a job every Friday at 9 P.M. (i.e., 21:00)?
25-35.	What interval value can you use to execute a job every Saturday and Sunday at 6 A.M.?
25-36.	What interval value can you use to execute a job at 11 P.M. of the last day of every month?
25-37.	How can you retrieve the values of the job, next_date, and broken_flag ...