dbms_job issue

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
orcl__dba
Posts: 1
Joined: Fri Nov 03, 2006 6:21 am
Location: Pakistan

dbms_job issue

Post by orcl__dba »

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







**********************************************************
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

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
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests