Home » RDBMS Server » Server Administration » Regarding dbms job
Regarding dbms job [message #203975] Fri, 17 November 2006 02:52 Go to next message
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
Re: Regarding dbms job [message #204113 is a reply to message #203975] Fri, 17 November 2006 22:25 Go to previous messageGo to next message
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.
Re: Regarding dbms job [message #204136 is a reply to message #204113] Sat, 18 November 2006 01:16 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: grant from db to another db
Next Topic: ORA-00205, ORA-01507
Goto Forum:
  


Current Time: Fri Dec 09 04:07:11 CST 2016

Total time taken to generate the page: 0.10735 seconds