Home » SQL & PL/SQL » SQL & PL/SQL » How To Alter Current Schedule Job via DBMS_SCHEDULER
How To Alter Current Schedule Job via DBMS_SCHEDULER [message #357276] Tue, 04 November 2008 09:37 Go to next message
wtolentino
Messages: 196
Registered: March 2005
Senior Member
i have this piece of code below that was run a year ago. i need to change the schedule time from 18:30:00 to 17:30:00. how can i alter the schedule time?

  BEGIN
    dbms_scheduler.create_job(
    job_name        => 'BULKLOAD_PRE_PACK',
    job_type        => 'STORED_PROCEDURE',
    job_action      => 'BULKLOAD_EXPORT',
    start_date      => TO_DATE('28-MAR-2007 18:30:00','DD-MON-YYYY HH24:MI:SS'),
    repeat_interval => 'FREQ=DAILY; BYDAY=MON,TUE,WED,THU,FRI; BYHOUR=18; BYMINUTE=30',
    enabled         => FALSE,
    comments        => 'Creates data for Special Charge Voucher');
  END;
Re: How To Alter Current Schedule Job via DBMS_SCHEDULER [message #357283 is a reply to message #357276] Tue, 04 November 2008 10:24 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe the simplest way id to drop and recreate it, doesn't it?

Regards
Michel
Previous Topic: Issue with Definer's Rights
Next Topic: htp.formOpen(...) problem
Goto Forum:
  


Current Time: Sat Dec 03 01:10:35 CST 2016

Total time taken to generate the page: 0.27926 seconds