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
|
|
|
|
|
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.
|
|
|