Syntax dbms_job.interval ???

[mike2000]

Could someone help me with the syntac below, Bascially, I want this package to be run at 4:00AM every Sat morning.

var j number
begin
dbms_job.submit
(
:j,
'SYS.DBMS_UTILITY.ANALYZE_SCHEMA(''LIS'',''COMPUTE'');',
'NEXT_DAY(trunc(sysdate),''SATURDAY'')+1/6'
);
COMMIT;
end;
/

when I look into INTERVAL and it said "NULL", how can I set the interval since I want this job to be run every Sat at 4:00AM???


Thanks

[rotem_fo]

Hi
Issue:

-- start --
var j number
begin
dbms_job.submit(:j,'SYS.DBMS_UTILITY.ANALYZE_SCHEMA(''LIS'',''COMPUTE'');');
dbms_job.interval(:j,'NEXT_DAY(trunc(sysdate),''SATURDAY'')+1/6');
commit;
end;
/
-- end --

[jmodic]

If you want to submit your job right now (immediately) and then every Saturday at 4:00AM, you would use:

var j number
begin
dbms_job.submit
(
:j,
'SYS.DBMS_UTILITY.ANALYZE_SCHEMA(''LIS'',''COMPUTE'');',
SYSDATE,
'NEXT_DAY(trunc(sysdate),''SATURDAY'')+1/6'
);
COMMIT;
end;

If you want to submit it next Saturday and then repeatedly every Saturday, you would use:

var j number
begin
dbms_job.submit
(
:j,
'SYS.DBMS_UTILITY.ANALYZE_SCHEMA(''LIS'',''COMPUTE'');',
NEXT_DAY(trunc(sysdate),''SATURDAY'')+1/6,
'NEXT_DAY(trunc(sysdate),''SATURDAY'')+1/6'
);
COMMIT;
end;