Changing dbms_scheduler START_DATE.
Hi All,
I have an audit purging job which is created using DBMS_AUDIT_MGMT.create_purge_job.
However when I created the job, I didn't specify the start date of the job, so the job starts to run during the time of my creation.
JOB_NAME START_DATE REPEAT_INTERVAL NEXT_RUN_DATE ------------------------------ --------------------------------------- ------------------------------ ---------------------------------------DAILY_AUDIT_PURGE_JOB 23/10/18 11:41:36.511121000 上午 ASIA/KUA FREQ=HOURLY;INTERVAL=24 06/11/18 11:41:36.000000000 上午 ASIA/KUA LA_LUMPUR LA_LUMPUR
Now I wanted to set the next run date to run at 5am everyday instead of current time. I know that we cannot change the next run date, that's why i'm trying to change the start date using set_attribute method.However i'm getting ORA-01855 error when trying to do so. Can I know what did I did wrong? Below is the scripts I'm trying to run