Hi All,
I am trying to create a job and want that it should run every 10 minutes
below is the code for that along with the errors i am currently recieving .
please suggest.
************************************************************
SQL> DECLARE
2 JOBID NUMBER;
3 BEGIN
4 DBMS_JOB.SUBMIT
5 (JOBID,'TEST_JOB',TRUNC(SYSDATE)+16/24,'(SYSDATE)+10/1440');
6 END;
7 /
DECLARE
*
ERROR at line 1:
ORA-06550: line 1, column 102:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
:= . ( @ % ;
The symbol ";" was substituted for "END" to continue.
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 136
ORA-06512: at line 4
**********************************************************
dbms_job issue
Pl follow the instructions of the following link and let us know if any issue,
http://www.psoug.org/reference/dbms_job.html
Also share what was going wrong now this is your responsibility to have some RnD and to teach us as well. Have a nice day.
Thanks
http://www.psoug.org/reference/dbms_job.html
Also share what was going wrong now this is your responsibility to have some RnD and to teach us as well. Have a nice day.
Thanks
Who is online
Users browsing this forum: No registered users and 0 guests