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

Thread: DBMS_JOB Procedure!!!

Threaded View

  1. 05-05-2005, 07:42 AM #7
    Bonker
    Bonker is offline Junior Member
    Join Date
    May 2005
    Posts
    31
    after changing the procedure to print using utl_file or insert into table you can submit it by

    variable x number;
    exec dbms_job.submit(:x,'print_name;',trunc(sysdate),'trunc(sysdate)+30/24/60/60');
    commit;

    'trunc(sysdate)+30/24/60/60' to run every 30 seconds
    Last edited by Bonker; 05-05-2005 at 07:52 AM.
    Experience is a hard teacher because she gives the test first, the lesson afterwards.
    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