-
Hi all
Now, the jobs in the queue are getting executed after I changed the job_queue_interval to 5secs. But, I have one more problem. When the job gets executed it gives error -
ORA-12012: error on auto execute of job 15
ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 386
ORA-06512: at "SYS.DBMS_IREFRESH", line 450
ORA-06512: at "SYS.DBMS_REFRESH", line 182
ORA-06512: at line 1
After it got executed a number of times, the job was marked as BROKEN. Does anyone know why I am getting that invalid cursor problem. It works fine if I do dbms_job.run(15).
BTW, how many times does a job get executed with error before it is marked as broken?
regards
Daud
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|