OraFAQ Forum: SQL & PL/SQL » DBMS_SCHEDULER

Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_SCHEDULER - job to be created (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi)

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

DBMS_SCHEDULER - job to be created [message #396900]

Wed, 08 April 2009 06:05

NewLife
Messages: 170
Registered: April 2008

Senior Member

Hi Guys,

I need to create a job with at the following interval:

It should run on the first sunday of every month at 00:30:00, i.e 30 minutes past midnight.

Please can some one help me.

Also since i am on Oracle 10g, Is it easier to use DBMS_SCHEDULER ?

Report message to a moderator

Re: DBMS_SCHEDULER - job to be created [message #396902 is a reply to message #396900]

Wed, 08 April 2009 06:15

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> with data as (select sysdate+31*(level-1) d from dual connect by level <= 10)
  2  select d, 
  3         trunc(next_day(last_day(d),'Sunday'))+1/48 next_d
  4  from data
  5  order by 1
  6  /
D                             NEXT_D
----------------------------- -----------------------------
Wednesday 08/04/2009 13:14:42 Sunday    03/05/2009 00:30:00
Saturday  09/05/2009 13:14:42 Sunday    07/06/2009 00:30:00
Tuesday   09/06/2009 13:14:42 Sunday    05/07/2009 00:30:00
Friday    10/07/2009 13:14:42 Sunday    02/08/2009 00:30:00
Monday    10/08/2009 13:14:42 Sunday    06/09/2009 00:30:00
Thursday  10/09/2009 13:14:42 Sunday    04/10/2009 00:30:00
Sunday    11/10/2009 13:14:42 Sunday    01/11/2009 00:30:00
Wednesday 11/11/2009 13:14:42 Sunday    06/12/2009 00:30:00
Saturday  12/12/2009 13:14:42 Sunday    03/01/2010 00:30:00
Tuesday   12/01/2010 13:14:42 Sunday    07/02/2010 00:30:00

Regards
Michel

Report message to a moderator

Re: DBMS_SCHEDULER - job to be created [message #396908 is a reply to message #396902]

Wed, 08 April 2009 06:24

NewLife
Messages: 170
Registered: April 2008

Senior Member

Hmmmmm Hey thenks for the query...I am just looking at how can i incorporate it into the job ?

Report message to a moderator

Re: DBMS_SCHEDULER - job to be created [message #396909 is a reply to message #396908]

Wed, 08 April 2009 06:27

bonker
Messages: 402
Registered: July 2005

Senior Member

Read this it may help you.

http://www.oracle-base.com/articles/10g/Scheduler10g.php

Report message to a moderator

Re: DBMS_SCHEDULER - job to be created [message #396910 is a reply to message #396908]

Wed, 08 April 2009 06:36

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to set NEXT_DATE parameter of SUBMIT function with the formula.

Regards
Michel

Report message to a moderator

Re: DBMS_SCHEDULER - job to be created [message #396911 is a reply to message #396910]

Wed, 08 April 2009 06:42

NewLife
Messages: 170
Registered: April 2008

Senior Member

Hey Michel thanks Smile

and bonker, you too, I am looking at the possibility of using dbms_scheduler Smile

Report message to a moderator

Previous Topic:	SQL Non Equi Join
Next Topic:	Maximum Value Wihtout using Oracle Functions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 11:48:07 CST 2024