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

Thread: DBMS_JOB failed, please help.

Threaded View

  1. 01-15-2003, 05:25 PM #6
    supower's Avatar
    supower
    supower is offline Working member
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    SQL> var jobno number;
    SQL> begin
    DBMS_JOB.SUBMIT(:jobno, 'DBMS_UTILITY.ANALYZE_SCHEMA (''SCOTT'', ''COMPUTE'');' ,SYSDATE+1/24, 'trunc(sysdate + 1) + 1/6');
    COMMIT;
    end;
    /


    ---''SCOTT'', ''COMPUTE''
    ---'' is two single quote
    Last edited by supower; 01-15-2003 at 05:27 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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