Job creation

Like most object types in the database, as seen at the beginning of Chapter 1, Oracle enables us to create Scheduler objects. The privileges create job and create external job are very important. They should normally be used when building an application system. Also, there is a create any job privilege, which can be useful when you need to create a job in a different schema. Normally, this privilege should not be granted to anyone. It will allow the grantee to run an arbitrary code on any schema, which is not particularly desirable. Instead, just log on to the correct schema and perform the tasks using the correct privileges. The following privileges can be used:

System Privilege	Description
create jobs	This privilege allows the grantee to create not only jobs but also chains, schedules, and programs. A schema can always alter and drop the scheduler objects in their own schemas even without the create jobs privilege. For chains, we need more privileges.
create external...