Summary
In this chapter, we have seen:
The privileges needed to create regular jobs
The privileges needed to create external jobs
The privileges needed to execute jobs
The risk of granting the
create any jobprivilegeThe privileges needed to do maintenance on the Scheduler system
Where the logging goes
How to get rid of the log entries—either manually or automatically
How to completely disable the Scheduler for maintenance
How to disable the scheduler on database start
How the
restartablejob attribute worksHow we can define
job_priorityHow the
job_priorityis used only with the samejob_classandstart_dateHow to use the Schedule limit
How to specify job over the
max_run_durationeventHow to use the job log to find the definition of a deleted job
How to check the log retention
Which tables to check for growth when using Scheduler logging
In the next chapter, we will be looking at managing resources.
