Database Administration (MOSC)

MOSC Banner

Changing dbms_scheduler START_DATE.

edited Nov 11, 2018 8:30PM in Database Administration (MOSC) 20 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center