OraFAQ Forum: SQL & PL/SQL » Scheduling job at 6 am and 7.30 pm

Home » SQL & PL/SQL » SQL & PL/SQL » Scheduling job at 6 am and 7.30 pm (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Scheduling job at 6 am and 7.30 pm [message #648137]

Wed, 17 February 2016 08:16

sss111ind
Messages: 634
Registered: April 2012
Location: India

Senior Member

Hi All,

How can we schedule a job to run at 6 am and 7.30 pm . Please suggest.

BEGIN
  dbms_scheduler.create_job (
    job_name        => 'TEST_job',
    job_type        => 'STORED_PROCEDURE',
    job_action      => 'TEST_EMP',
    start_date      => systimestamp,
    repeat_interval => 'FREQ=DAILY; BYHOUR=18; BYMINUTE=00; BYSECOND=00;',
    end_date        => NULL,
    enabled         => true,
    comments        => 'Job defined ');
end;

Regards,
Nathan

[Updated on: Wed, 17 February 2016 08:19]

Report message to a moderator

Re: Scheduling job at 6 am and 7.30 pm [message #648138 is a reply to message #648137]

Wed, 17 February 2016 08:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

scheduler same task twice; once at 0600 & once at 1930 each to run daily.

Report message to a moderator

Re: Scheduling job at 6 am and 7.30 pm [message #648139 is a reply to message #648138]

Wed, 17 February 2016 08:35

sss111ind
Messages: 634
Registered: April 2012
Location: India

Senior Member

Thank You BlackSwan ,

You mean to say, define two scheduler with 6 am and 7.30 pm to run the task. Is any way to do it in single scheduler.

Regards,
Nathan

Report message to a moderator

Re: Scheduling job at 6 am and 7.30 pm [message #648140 is a reply to message #648139]

Wed, 17 February 2016 08:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is any way to do it in single scheduler.
you are free to do it any way that meets your requirements.
Nobody here prevents you from doing as you desire.
What is advantage of single scheduler?

Report message to a moderator

Re: Scheduling job at 6 am and 7.30 pm [message #648169 is a reply to message #648138]

Wed, 17 February 2016 21:02

Solomon Yakobson
Messages: 3273
Registered: January 2010
Location: Connecticut, USA

Senior Member

BlackSwan wrote on Wed, 17 February 2016 09:26

scheduler same task twice; once at 0600 & once at 1930 each to run daily.

Bad suggestion. You have to maintain 2 sets of code. Proper way is creating single job with combined schedule.

SY.

Report message to a moderator

Re: Scheduling job at 6 am and 7.30 pm [message #648172 is a reply to message #648169]

Wed, 17 February 2016 22:07

Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA

Senior Member

BEGIN
  dbms_scheduler.create_schedule (
    schedule_name   => 'SCHED1', 
    repeat_interval => 'FREQ=DAILY; BYHOUR=6; BYMINUTE=00; BYSECOND=00;');
  dbms_scheduler.create_schedule (
    schedule_name   => 'SCHED2', 
    repeat_interval => 'FREQ=DAILY; BYHOUR=19; BYMINUTE=30; BYSECOND=00;'); 
  dbms_scheduler.create_job (
    job_name        => 'TEST_job',
    job_type        => 'STORED_PROCEDURE',
    job_action      => 'TEST_EMP',
    start_date      => systimestamp,
    repeat_interval => 'SCHED1,SCHED2',
    end_date        => NULL,
    enabled         => true,
    comments        => 'Job defined ');
END;
/

Report message to a moderator