dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: dbms_job sched

Hybrid View

  1. #1
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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
  •  


Click Here to Expand Forum to Full Width