During the installation, we get an error saying some of the jobs are still running.
when we check the jobs, those are scheduled to run in different time, no any interruption to build.
During the installation, we get an error saying some of the jobs are still running.
when we check the jobs, those are scheduled to run in different time, no any interruption to build.
Hi
Before running the installation, kindly check the scheduled job in that particular database using the query,
Select job_name, enabled from DBA_SCHEDULER_JOBS
Once you identify the scheduled jobs which are enabled, then disable it using the query
exec dbms_scheduler.disable('JOB_NAME');
After you performed the installation successfully, then enabled it using the query
exec dbms_scheduler.enable('JOB_NAME');
I hope the above suggested method can help to solve the reported issue.
Best Regards,
Sajid Ahmed
Hi
During the installation, database parameter job_queue_processes is usually set to 0 in order to prevent issues like this. However, this could fail if scheduler processes are already running. If you encounter the issue every time doing the installation, you can run following PL/SQL method to stop scheduler processes before the installation or even during the installation.
BEGIN
Install_Tem_SYS.Stop_Scheduler_Processes;
END;
Hope this helps!
Thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.