This content has been marked as final. Show 4 replies
Thank you for providing us with all the information we need to help you.
We have the Oracle version number.
We have the code you were running.
We have the full and complete error stack so we know what went wrong.
We have output from data dictionary tables such as DBA_SCHEDULER_JOBS and DBA_SCHEDULER_RUNNING_JOBS.
So the answer is the same as for this question: "My car won't start please tell me why?"
In other words ... no details ... no answers are possible.
thank for help :) ,
Every thing goes fine except one thing which is , why the job do not run automatically next time that specified in the create statement, i tried to find any error but i cant find one,
look when i use the Toad and click on "run job" the job run without any error,
"why the job do not run automatically"
i create the same job in another database in separate machine it work automatically, but the difference is that i do not use hijrah Calendar which i have to use it in the main database;
Check system parameter job_queue_processes. It must be non zero.
to set use
show parameter job_queue_processes
ALTER SYSTEM SET job_queue_processes=<put number of processes> scope=both;
thank you v much