OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Regarding dbms job

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

Regarding dbms job [message #203975]

Fri, 17 November 2006 02:52

rajuakula
Messages: 63
Registered: March 2005

Member

Hi,

I have a stored proc and I need to execute it every month of 25th.How do I do it using dbms_job?

thanks in advance

Report message to a moderator

Re: Regarding dbms job [message #204113 is a reply to message #203975]

Fri, 17 November 2006 22:25

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi raj

YOu can try this
SQL> select sysdate ,last_day(sysdate) + 25 from dual;

SYSDATE LAST_DAY(
--------- ---------
18-FEB-04 25-MAR-04

hope this helps
Mohammad Taj.

Report message to a moderator

Re: Regarding dbms job [message #204136 is a reply to message #204113]

Sat, 18 November 2006 01:16

selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai

Senior Member

Hi,

Use this,It may be useful for you

dbms_job.submit(:jobno, 'SP_NAME', SYSDATE,last_day(sysdate) + 25 );

Thankx and Regards
Selvakumar.R

[Updated on: Sat, 18 November 2006 01:17]

Report message to a moderator

Re: Regarding dbms job [message #204137 is a reply to message #204136]

Sat, 18 November 2006 01:20

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi

dbms_job.submit(:jobno, 'SP_NAME', SYSDATE,last_day(sysdate) + 25 );
i know above cmd is working ...
SQL> select sysdate ,last_day(sysdate) + 25 from dual;

through above statement i am just point how can set sysdate with require result...

regards
Mohammad taj.

Report message to a moderator

Previous Topic:	grant from db to another db
Next Topic:	ORA-00205, ORA-01507

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:48:00 CDT 2024