|
|
|
|
| Re: Call Stored procedure with specific time [message #369805 is a reply to message #369786] |
Fri, 13 October 2000 13:03   |
Suresh.N
Messages: 41
Registered: March 2000
|
Member |
|
|
Hi Suresh!
I tried like by using Dbms_Job.Sumbit...
CREATE TABLE T1(DATETIME VARCHAR2(20));
CREATE OR REPLACE PROCEDURE P1
IS
BEGIN
INSERT INTO T1 VALUES
(TO_CHAR(SYSDATE,'DD/MM/YYYY 24HH:MI:SS'));
END ;
procedure created..
DECLARE
JOBID NUMBER;
BEGIN
DBMS_JOB.SUBMIT(JOBID,'P1',SYSDATE+1);
END;
Error while executing the above..
Please give sugestion.
Correct me I am wrong..
How to use the Dbms_Job.Submit.
If I want to execute that procedure for every hour what should i do?
Thanks and Reagrds
Suresh.N
|
|
|
|
| Re: Call Stored procedure with specific time [message #369806 is a reply to message #369786] |
Fri, 13 October 2000 13:18 |
Suresh
Messages: 189
Registered: December 1998
|
Senior Member |
|
|
pass 4 params to dbms_job.submit procedure
1. jobno out parameter
2. job to do
3. next time to be executed (sysdate is default)
4. interval
change your pl/sql block to
DECLARE
JOBID NUMBER;
BEGIN
DBMS_JOB.SUBMIT(JOBID,'P1',sysdate,SYSDATE+1);
END;
Suresh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
