6 Replies Latest reply: Nov 6, 2013 12:17 PM by Barbara Boehmer RSS

    need help to schedule a job

    985871


      Hi Friends ,

       

      I need help in scheduling the below job which should run every day at 5.30 pm . i am using oracle 10.2.0.4.

      
      
      DECLARE 
          X NUMBER; 
        BEGIN 
          SYS.DBMS_JOB.SUBMIT 
            (
      job       => X 
             ,what     
      => 'QOSDEV. BMC_HSCR_STATUS;' 
             ,interval  =>
      'trunc(SYSDATE)+(17/24)' 
        
          ); 
         SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' ||
      to_char(x)); 
      
       END; 
           commit;
      

       

      Thanks

      DBApps