Sunday, October 30, 2011

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