The repeat_interval argument specifies that this job runs every other day until it reaches the end date and time. The job runs as the user who created the job. Repeat_interval => 'FREQ=DAILY INTERVAL=2', /* every other day */Įnd_date => '20-NOV-08 07.00.00 PM Australia/Sydney',īecause no destination_name attribute is specified, the job runs on the originating (local) database. Job_action => 'OPS.SALES_PKG.UPDATE_SALES_SUMMARY', The NLS environment of the job, when it runs, is the existing environment at the time the job was created.Įxample 29-1 demonstrates creating a database job called update_sales, which calls a package procedure in the OPS schema that updates a sales summary table: The job owner is the user in whose schema the job is created. The creator of a job is, therefore, not necessarily the job owner. You can create a job in another schema by specifying schema.job_name. For example, to set the logging_level attribute for a job, you must call SET_ATTRIBUTE after calling CREATE_JOB.
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 kommentar(er)
