xoxomos
asked on
dbms_job question
This job is scheduled to run every Sunday at 7 a.m.
DECLARE
JobNo dba_jobs.job%TYPE;
BEGIN
DBMS_JOB.SUBMIT(JobNo,'DBM S_STATS.GA THER_SCHEM A_STATS(ow nname=>''B B_BB60'',
cascade=>TRUE, method_opt=>''FOR ALL INDEXED COLUMNS SIZE AUTO'');',
trunc(sysdate) + 7/24 + 8 - to_char(sysdate,'D'), 'trunc(sysdate) + 7 + 7/24');
COMMIT;
END;
What is the 'D' in (sysdate,'D') ?
What specifies 7 a.m ?
Is there a link to docs ?
what is the +8 ?
DECLARE
JobNo dba_jobs.job%TYPE;
BEGIN
DBMS_JOB.SUBMIT(JobNo,'DBM
cascade=>TRUE, method_opt=>''FOR ALL INDEXED COLUMNS SIZE AUTO'');',
trunc(sysdate) + 7/24 + 8 - to_char(sysdate,'D'), 'trunc(sysdate) + 7 + 7/24');
COMMIT;
END;
What is the 'D' in (sysdate,'D') ?
What specifies 7 a.m ?
Is there a link to docs ?
what is the +8 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER