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:
| ||||||
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 ... |
Get Oracle PL/SQL Programming: A Developer's Workbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.