PL/SQL (MOSC)

MOSC Banner

DBA_SCHEDULER_JOBS

edited Mar 10, 2017 8:46AM in PL/SQL (MOSC) 7 commentsAnswered ✓

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';

     

OWNERJOB_NAMELAST_DATE_TIMENEXT_DATE_TIMEJOB_ACTION
SYSSTANDARD_OS_AUDIT_TRAIL_PURGE28-02-17 11:18:1201-03-17 11:18:10BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(4, TRUE);  END;

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