「Oracle入門」ジョブの情報を取得する
SQL構文下記
SELECT JOB_NAME,OWNER,ENABLED,COMMENTS, LOGGING_LEVEL,JOB_CLASS,SCHEDULE_NAME, JOB_PRIORITY,JOB_WEIGHT FROM SYS.DBA_SCHEDULER_JOBS;
Coding Changes the World
SQL構文下記
SELECT JOB_NAME,OWNER,ENABLED,COMMENTS, LOGGING_LEVEL,JOB_CLASS,SCHEDULE_NAME, JOB_PRIORITY,JOB_WEIGHT FROM SYS.DBA_SCHEDULER_JOBS;