It enables you to create, alter, and drop job classes, windows, and window groups. This is the most important privilege for administering the Scheduler. In this case, the job must have been created in your schema by another user with the CREATE ANY JOB privilege.Įnables jobs to use programs or chains from any schema You will always be able to alter and drop jobs, schedules and programs in your own schema, even if you do not have the CREATE JOB privilege. This privilege enables you to create jobs, chains, schedules, and programs in your own schema. To run a job of type 'EXECUTABLE', you must have this privilege and the CREATE JOB privilege. Owners of jobs of type 'EXECUTABLE' or jobs that point to programs of type 'EXECUTABLE' require this privilege. Required to create jobs that run outside of the database. This privilege is very powerful and should be used with care because it allows the grantee to execute code as any other user. This privilege enables you to create, alter, and drop jobs, chains, schedules, and programs in any schema except SYS. SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_SCHEDULER' SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_SCHEDULER' TYPE bylist IS VARRAY (256) OF PLS_INTEGER TYPE scheduler_filewatcher_request IS OBJECT ( Matching_requests SYS.SCHEDULER_FILEWATCHER_REQ_LIST) TYPE scheduler_filewatcher_result IS OBJECT ( SELECT dbms_metadata.get_ddl('TYPE', 'RE$NV_LIST) TYPE scheduler$_chain_link_list IS TABLE OF sys.sc TYPE SCHEDULER$_STEP_TYPE_LIST IS TABLE OF sys.sch TYPE SCHEDULER$_RULE_LIST IS TABLE OF sys.schedule Retry count: %retry_count% Error code: %error_code% Error message: %error_message%' Log id: %log_id% Job class: %job_class_name% Run count: %run_count% Failure count: %failure_count% 'Job: %job_owner%.%job_name%.%job_subname% Event: %event_type% Date: %event_timestamp% 'Oracle Scheduler Job Notification - %job_owner%.%job_name%.%job_subname% %event_type%'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |