-
how do you shedule a job using dbms_job to run every Sat at 3:00AM ???
let sat if I have this package below:
var j number
begin
dbms_job.submit
(
:j,
'SYS.DBMS_UTILITY.ANALYZE_SCHEMA(''CONTRACKER'',''COMPUTE'');',
sysdate,'sysdate+(90/(24*60*60))'
);
COMMIT;
end;
/
The above job run very 90 sec but now I have it to run every sat at 3:00am
thanks
-
NEXT_DAY(trunc(sysdate)+1/8,'SATURDAY')
[Edited by pando on 10-10-2002 at 04:33 PM]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|