This discussion is archived
3 Replies Latest reply: Nov 27, 2013 12:31 PM by sb92075 RSS

How to disable dbms_scheduler globally?

31cf6fd1-7de6-498a-a881-3181d896aa77 Newbie
Currently Being Moderated

Hi all,


Is there any way to disable it using some parameter or command? The DB was cloned and it has tons of DB_LINKS that point to production DB (the links are created using connect string). When we start the database, dbms_scheduler starts running it's job, connecting to PROD using those links. There is absolutely no way for us to bring DB and create a dynamic sql to disable those jobs one by one. We need to be able to disable dbms_scheduler ideally without bringing the DB up or at least within the first seconds of it being up.

Please, let me know if you are aware of such an easy way




  • Correct Answers - 10 points
  • Helpful Answers - 5 points