If TRUE, the job is permitted to run when the database is in restricted mode, provided that the job owner is permitted to log in during this mode In an Oracle Data Guard environment, the database role (' PRIMARY' or ' LOGICAL STANDBY') for which the job runs The name of a single external destination or database destination, or a group name of type external destination or database destination The credential to use for a single destination or the default credential for a group of destinations The instance ID of the instance that the job must run on If FALSE, then an event is discarded if it is raised while the job that handles it is already running, 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 TRUE and if the job start_date is null, then when the default_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. Indicates whether the job should be enabled immediately after creating it ( TRUE) or not ( FALSE) If TRUE (the default), indicates that the job should be dropped once completed Equivalent to the stop_on_window_close job attribute described in the SET_ATTRIBUTE Procedure. Indicates whether the job is stopped when the window that it runs in ends ( TRUE) or not ( FALSE). Indicates whether the job is restartable ( TRUE) or not ( FALSE) Maximum number of failures tolerated before the job is marked as broken Maximum number of runs before the job is marked as completed Weight of the job for parallel execution. Do not change the value of this attribute from the default, which is 1. *** Deprecated in Oracle Database 11 g Release 2 (11.2). Maximum delay time between scheduled and actual job start before a job run is canceledįile watcher name or queue specification for event-based jobs
Name of the schedule that specifies when the job has to execute Job action type (' PLSQL_BLOCK', ' STORED_PROCEDURE', ' EXECUTABLE', or ' CHAIN')
Oracle filewatcher code#
This is either the code for an anonymous PL/SQL block or the name of a stored procedure, external executable, or chain. Table 129-3 JOB_DEFINITION Object Type Attributes Attribute
0 kommentar(er)
