|
|
|
|
|
|
|
|
- Style of the job:
- REGULAR
- LIGHTWEIGHT
|
|
|
- Name of the program that the job runs
|
|
|
- Inline action of the job. This is either the code for an anonymous PL/SQL block or the name of a stored procedure, external executable, or chain.
|
|
|
- Job action type ('PLSQL_BLOCK', 'STORED_PROCEDURE', 'EXECUTABLE', or 'CHAIN')
|
|
|
- Name of the schedule that specifies when the job has to execute
|
|
|
- Inline time-based schedule
|
|
|
- Maximum delay time between scheduled and actual job start before a job run is canceled
|
|
|
- Start date and time of the job
|
|
|
- End date and time of the job
|
|
|
- Event condition for event-based jobs
|
|
|
- File watcher name or queue specification for event-based jobs
|
|
|
|
|
|
|
|
|
|
|
|
- *** Deprecated in Oracle Database 11gR2. Do not change the value of this attribute from the default, which is 1.
- Weight of the job for parallel execution.
|
|
|
- Maximum run duration of the job
|
|
|
- Maximum number of runs before the job is marked as completed
|
|
|
- Maximum number of failures tolerated before the job is marked as broken
|
|
|
|
|
|
- Indicates whether the job is restartable (TRUE) or not (FALSE)
|
|
|
- Indicates whether the job is stopped when the window that it runs in ends (TRUE) or not (FALSE). Equivalent to thestop_on_window_close job attribute described in the SET_ATTRIBUTE Procedure.
|
|
|
- State changes that raise events
|
|
|
|
|
|
- If TRUE (the default), indicates that the job should be dropped once completed
|
|
|
- Indicates whether the job should be enabled immediately after creating it (TRUE) or not (FALSE)
|
|
|
- If TRUE and if the job start_date is null, then when thedefault_timezone scheduler attribute is changed, the Scheduler recomputes the next run date and time for this job so that it is in accordance with the new time zone.
|
|
|
- For event-based jobs only.
- If TRUE, on the arrival of the specified event, the Scheduler creates a new lightweight job to handle that event, so multiple instances of the same event-based job can run in parallel.
- If FALSE, then an event is discarded if it is raised while the job that handles it is already running,
|
|
|
|
|
|
- The instance ID of the instance that the job must run on
|
|
|
- The credential to use for a single destination or the default credential for a group of destinations
|
|
|
- The name of a single external destination or database destination, or a group name of type external destination or database destination
|
|
|
- In an Oracle Data Guard environment, the database role ('PRIMARY' or 'LOGICALSTANDBY') for which the job runs
|
- allow_runs_in_restricted_mode
|
- If TRUE, the job is permitted to run when the database is in restricted mode, provided that the job owner is pe
|