DBMS_JOBS DOES NOT WORK
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DBMS_JOBS DOES NOT WORK

  1. #1
    Join Date
    Sep 2002
    Posts
    411
    Hi all,

    I have the follow job will be executed as follow:

    var j number
    begin
    dbms_job.submit
    (
    :j,
    'SYS.DBMS_UTILITY.ANALYZE_SCHEMA(''TEST'',''COMPUTE'');
    ',sysdate,'sysdate+(90/(24*60*60))'
    );
    COMMIT;
    end;


    THIS Job suppose to start every 90 sec but for some reason, it doesn't start at all.

    I did check the DBA_JOBS and the job is there. Any suggestions
    Share on Google+

  2. #2
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Duplicate thread:

    http://www.dbasupport.com/forums/sho...threadid=29950

    Closing,

    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong
    Share on Google+

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