Amazon books

Saturday, November 30, 2013

exec dbms_scheduler.RUN_JOB is not running the JOB. Session just HANG!!

I just got this problem,


exec dbms_scheduler.RUN_JOB('SYSTEM.B2W_GATHER_STATS_RISCO_DS');

Even using the owner of the job, the session hang and did not execute the job.

I had to use this option below:

exec DBMS_SCHEDULER.run_job (job_name => 'B2W_GATHER_STATS_RISCO_DS');

Now it works.

Best Regards,
Paulo Portugal