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
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
No comments:
Post a Comment