Skip to content
May 5, 2011 / doganay

NEXT DATE SET FOR A SPECIFIC JOB

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Hi,

whenever sqlerror exit;
set verify off
set feedback off
declare
 job_num number;
begin
 select job into job_num from dba_jobs where what like '%my_procedure%';
--In this example we set next_date to tomorrow 08:00
 dbms_job.next_date(job_num,trunc(SYSDATE)+1+8/24);
 commit;
end;
/
set verify on
set feedback on
whenever sqlerror continue;

try and pray 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: