DBA_SCHEDULER_JOBS
Dear All,
Could anybody tell me how to change "NEXT_DATE_TIME" value of my DBA_SCHEDULER_JOBS ?
For example, there is a output of my select query:
select OWNER,JOB_NAME,to_char(last_start_date,'DD-MM-YY HH24:MI:SS') Last_date_time, to_char(next_run_date,'DD-MM-YY HH24:MI:SS') Next_Date_Time, JOB_ACTION from DBA_SCHEDULER_JOBS
where JOB_NAME='STANDARD_OS_AUDIT_TRAIL_PURGE';
OWNER | JOB_NAME | LAST_DATE_TIME | NEXT_DATE_TIME | JOB_ACTION |
SYS | STANDARD_OS_AUDIT_TRAIL_PURGE | 28-02-17 11:18:12 | 01-03-17 11:18:10 | BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(4, TRUE); END; |