Create a DBMS_JOB

July 30, 2012 admin Oracle, Scripts

–schedules this job to run immediately and then every hour after that
DECLARE
JobNo dba_jobs.job%TYPE;
BEGIN
DBMS_JOB.SUBMIT (
job => JobNo,
what => ‘begin SESSIONS_RM(minutes=>180); end;’,
next_date => SYSDATE,
interval => ‘SYSDATE + 1/24’);
COMMIT;
END;
/

TAR / TAR.Z Set date+time (NLS_DATE_FORMAT)