troubleshooting Question

error in oracle dbms.job

Avatar of sharscho
sharscho asked on
DatabasesOracle Database
5 Comments1 Solution737 ViewsLast Modified:
Hi experts, I have a quick question.

I need to create a scheduled job in my db and I get an error that the jobno has to be declared. Is there somthing wrong with the script?

the job:

DECLARE jobno number;
BEGIN
   DBMS_JOB.SUBMIT(jobno,
   'CHK_AVI_DGR;',
   TO_DATE('maandag, december 12, 2011 03 05 49 PM', 'DAY, MONTH DD, YYYY HH:MI:SS AM'),
   'SYSDATE+1/24');
COMMIT;
END;
/

The error:
DECLARE jobno number;

*

ERROR at line 1:

ORA-06550: line 1, column 93:

PLS-00201: identifier 'CHK_AVI_DGR' must be declared

ORA-06550: line 1, column 93:

PL/SQL: Statement ignored

ORA-06512: at "SYS.DBMS_JOB", line 79

ORA-06512: at "SYS.DBMS_JOB", line 136

ORA-06512: at line 3
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros