We're using a job scheduling system that runs on top of DBMS_JOB. It uses a master job to create one-time jobs. We deploy the same set of jobs to all our clients, but can specify which jobs should only run at certain clients. We get occasional problems with a process run by a job hanging. The main cause of this is UTL_TCP not timing out...
I have made this job,that should be executed in an interval of 1 minute,but it's not working. When I use execute dbms_job.run(2); it gets executed. printe is a procedure Please suggest! BEGIN DBMS_JOB.SUBMIT ( job =>:job_no, WHAT=>'printe;',--Procedure next_date=>sysdate+1/24*60, ...
Im programing a job in oracle in order to execute a store procedure, but when the time comes it just does not happend any thing for no reason. Is there some kind of log where I can see if an error happend or something? Im using the dbms_job package to create the job Tnks. ...