SCHEDULER_JOB in oracle data base
SELECT JOB_NAME,JOB_TYPE,JOB_ACTION,SCHEDULE_NAME,SCHEDULE_TYPE,JOB_CLASS,STATE FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME='JobName';
--------------------------------------------------------------------------------------
SELECT owner, program_name, enabled FROM dba_scheduler_programs;
No comments:
Post a Comment