FINDING DBA_JOBS ALTER HISTORY
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
NLSRTL Version 10.2.0.4.0 - Production
Above given is the oracle version we use. We have list of jobs scheduled using dbms_job.submit.
This is interval given in one of the jobs.
INTERVAL->
TRUNC(LEAST(NEXT_DAY(SYSDATE,'MON'),
NEXT_DAY(SYSDATE,'TUE'),NEXT_DAY(SYSDATE,'WED'),
NEXT_DAY(SYSDATE,'THU'), NEXT_DAY(SYSDATE,'FRI')))+(DECODE(TO_CHAR(SYSDATE+1,'DY'),'FRI',20,22)/24)
This has not run yesterday. There has not thrown any error and We found it is scheduled to run coming monday directly.
Is there a way to find if anybody modified the schedule manually ?
Thank you for your help.