dbms_job issue
Posted: Fri Nov 03, 2006 7:24 am
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
**********************************************************
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
**********************************************************