-
dbms_job sched
Ok I'm a dbms_jobs idiot, I admit it
I 'd like to try and get the following to run every saturday at 6pm
and it's not working !
tks
steve
variable jobno number;
EXEC DBMS_JOB.SUBMIT(:jobno,'dbms_stats.gather_schema_stats(ownname=> ''SYSADM'' , cascade=> TRUE);'
, trunc(sysdate),''SATURDAY'') + 18/24, 'NEXT_DAY (TRUNC(sysdate),''SATURDAY'') +18/24');
commit;
I'm stmontgo and I approve of this message
-
whoope, never mind
variable jobno number;
EXEC DBMS_JOB.SUBMIT(:jobno,'dbms_stats.gather_schema_stats(ownname=> ''SYSADM'' , cascade=> TRUE);' , next_day(trunc(sysdate),'SATURDAY') + 18/24, 'NEXT_DAY (TRUNC(sysdate),''SATURDAY'') +18/24');
commit;
does it,
tks
steve
I'm stmontgo and I approve of this message
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
|