「Oracle入門」ジョブを作成するメモ
メモ下記
1.ジョブ一覧確認 SQL> set pages 999 SQL> SELECT job_name FROM dba_scheduler_jobs; 2.ジョブ作成 SQL> BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'USER_MANAGE_JOBAA', program_name => 'ORA_PROGRAMAA', schedule_name => 'USER_MANAGE_INFO_SCHEDULE', enabled => TRUE); END; / 3.ジョブ確認 SQL> set pages 999 SQL> SELECT job_name FROM dba_scheduler_jobs;