Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Updating the job interval

978485Jun 19 2013 — edited Jun 20 2013


Hi all ,

please suggest me ,your help is greatly appreciated .

I have to update a job to run everyday at 8:00 pm .please verify if this is okay or do  i  need to make any more changes here .

DECLARE
   njob_id   all_jobs.job%TYPE;
BEGIN
   SELECT job
     INTO njob_id
     FROM all_jobs
   WHERE UPPER (what) LIKE '%EMP%';

   DBMS_JOB.INTERVAL(njob_id, 'NEXT_DAY(TRUNC(SYSDATE+1 ) + 20/24');
   DBMS_JOB.NEXT_DATE(njob_id, (TRUNC(SYSDATE+1 )+20/24);
   DBMS_OUTPUT.put_line ('The job interval is successfully changed');
EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.put_line (   'ERROR in changing the job interval !'
                            || SUBSTR (SQLERRM, 1, 200)
                           );
END;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2013
Added on Jun 19 2013
9 comments
1,494 views