| ORACLE JOBS PROBLEM [message #72481] |
Fri, 27 June 2003 07:43 |
Gulab Basha
Messages: 7
Registered: June 2003
|
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...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
