Re: CAN DBMS_SCHEDULER IN 10G ALTER JOB'S NEXT EXECUTION TIME AS DBMS_JOB?

cherry wrote:
> Ihave a scheduled job create and monitor using DBMS_JOB package in 8i.
> After upgrade to 10g, we recognize
> there is a new package DBMS_Scheduler which superseded DBMS_JOB and it
> is
> easier to moniter and manage through the EM.
>
> However, I know that there is a procedure NEXT_DATE in DBMS_JOB which
> alter job's next execution time but I can't find any similar function
> in DBMS_Scheduler. The Set_Attribute function only allows update of
> "start_date" or "end_date" but not the next run date.
>
> Any one knows how to change the next run time but doesn't affect the
> original scheduling? such that after running at the changed "next run
> time", it can retain the next run as the original interval defined.
>
> Thanks and Regards,
> Cherry

 BEGIN
  dbms_scheduler.create_job(

  job_name        => 'UW_File_Load',
  program_name    => 'Run_LOAD_DATA',
  start_date      => dbms_scheduler.stime,
  repeat_interval => 'FREQ=MINUTELY;INTERVAL=1',
  end_date        => dbms_scheduler.stime+1,
  enabled         => FALSE,
  auto_drop       => FALSE,
  comments        => 'UW Demo Job');

repeat_interval

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org