3 Replies Latest reply: Nov 27, 2013 2:31 PM by sb92075 RSS

    How to disable dbms_scheduler globally?

    1057288

      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

      Thanks,

      M

        • 1. Re: How to disable dbms_scheduler globally?
          sb92075

          31cf6fd1-7de6-498a-a881-3181d896aa77 wrote:

           

          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

          Thanks,

          M

           

          job_queue_processes = 0

          • 2. Re: How to disable dbms_scheduler globally?
            TSharma-Oracle

            If you are in 11g, try the following command. I have never personally tried it.

             

            exec  DBMS_SCHEDULER.set_scheduler_attribute('SCHEDULER_DISABLED', 'TRUE');

            • 3. Re: How to disable dbms_scheduler globally?
              TSharma-Oracle

              Sorry did not read your last line where you mentioned you want to disable it without being database up. I think I will go with sb92075 then.