oracle定時任務每天都會執行一次建立步驟

<code>CREATE JOB job_name
AS
sys.dbms_scheduler.create_job(job_name,
                              'DEFAULT_JOB_CLASS',
                              'job_desc');</code>

<code>sys.dbms_scheduler.create_job_subjob(job_name,
                                 'job_subname',
                                 'job_type',
                                 'job_parameters',
                                 'schedule_expression',
                                 'enabled');</code>

<code>sys.dbms_scheduler.enable(job_name);</code>

<code>CREATE JOB daily_job
AS
sys.dbms_scheduler.create_job(job_name,
                              'DEFAULT_JOB_CLASS',
                              'Daily job to execute a SQL query');

sys.dbms_scheduler.create_job_subjob(job_name,
                                 'daily_subjob',
                                 'SQL',
                                 'BEGIN
                                   SELECT COUNT(*)
                                   FROM users;
                                 END;',
                                 'INTERVAL 1 DAY',
                                 'TRUE');

sys.dbms_scheduler.enable(job_name);</code>