![]() ![]() Some job attributes cannot be set with CREATE_JOB, and instead must be set with DBMS_SCHEDULER.SET_ATTRIBUTE. You can also set the enabled argument of the CREATE_JOB procedure to TRUE, in which case the job is ready to be automatically run, according to its schedule, as soon as you create it. By default, jobs are disabled when created and must be enabled with DBMS_SCHEDULER.ENABLE to run. As soon as you enable a job, it is automatically run by the Scheduler at its next scheduled date and time. You can also optionally specify a credential name, a destination or destination group name, a job class, and other attributes. You must have the CREATE JOB privilege to create a job in your own schema, and the CREATE ANY JOB privilege to create a job in any schema except SYS.įor each job being created, you specify a job type, an action, and a schedule. ![]() You can create multiple jobs in a single transaction using the CREATE_JOBS procedure. This procedure is overloaded to enable you to create different types of jobs that are based on different objects. You use the CREATE_JOB procedure to create a single job. ![]() You create one or more jobs using the DBMS_SCHEDULER.CREATE_JOB or DBMS_SCHEDULER.CREATE_JOBS procedures or Enterprise Manager. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |