| ORACLE JOBS PROBLEM [message #57656] |
Fri, 27 June 2003 07:45  |
Gulab
Messages: 10
Registered: October 2002
|
Junior Member |
|
|
Hi,
Could you please help on my issue.
I have registered my job using following command:
VARIABLE JOBNO NUMBER;
EXEC DBMS_JOB.SUBMIT(:JOBNO,'DUMMYPROC;',SYSDATE,'SYSDATE + 1/(24*60)');
I have configured to run this job for a each minute. I have enforced this job to run first time by using following command:
EXEC DBMS_JOB.RUN(24);
My job should pick up in next minute automatically, whereas it is not happening. Can any one suggest me why this is not happening? As my system date is 1/1/1999 now. I need to test my program with this date.
Please help...
|
|
|
|
| Re: ORACLE JOBS PROBLEM [message #57661 is a reply to message #57656] |
Fri, 27 June 2003 10:31  |
Joe
Messages: 138
Registered: November 1999
|
Senior Member |
|
|
Gulab,
I believe you must put it inside a begin/end as:
sqlplus> VARIABLE JOBNO NUMBER;
sqlplus>BEGIN
sqlplus>EXEC DBMS_JOB.SUBMIT(:JOBNO,'DUMMYPROC;',SYSDATE,'SYSDATE + 1/(24*60)');
sqlplus>END;
|
|
|
|
| Re: ORACLE JOBS PROBLEM [message #57662 is a reply to message #57661] |
Fri, 27 June 2003 10:33 |
Joe
Messages: 138
Registered: November 1999
|
Senior Member |
|
|
without the exec!
sqlplus> VARIABLE JOBNO NUMBER;
sqlplus>BEGIN
sqlplus>DBMS_JOB.SUBMIT(:JOBNO,'DUMMYPROC;',SYSDATE,'SYSDATE + 1/(24*60)');
sqlplus>END;
|
|
|
|
| Re: ORACLE JOBS PROBLEM [message #57663 is a reply to message #57661] |
Fri, 27 June 2003 10:59 |
Gulab
Messages: 10
Registered: October 2002
|
Junior Member |
|
|
Hi Joe,
Thanks for your reply.
I have created job using the above syntax. I am able to enforce the jobs. But it is not picking after next interval.
Could you please suggest me any possible solution, please.
Thanks again,
Gulab.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
