4 Replies Latest reply: Apr 2, 2009 5:54 PM by 670676 RSS

    how to disable dbms jobs?

    627359
      Hi,


      one job is running in sys schema. i want to disable that job. how to disable that job?

      Thanks,

      Edited by: Mohammed_82 on Mar 29, 2009 10:55 AM
        • 1. Re: how to disable dbms jobs?
          670676
          Hello,
          Try
          execute dbms_scheduler.disable('owner.job')
          Example:
          execute dbms_scheduler.disable('SYS.GATHER_STATS_JOB')
          Regards,
          • 2. Re: how to disable dbms jobs?
            Kamran Agayev A.
            Hi Mohammad
            It's not Database related thread, please post your questions on related topic=> [Database - General|http://forums.oracle.com/forums/forum.jspa?forumID=61]

            For more information of DBMS_JOB, please refer to documentation:
            http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_job.htm#BABBICAJ

            - - - - - - - - - - - - - - - - - - - - -
            Kamran Agayev A. (10g OCP)
            http://kamranagayev.wordpress.com
            • 3. Re: how to disable dbms jobs?
              627359
              Hi,

              i am not able disable jobs

              this procedure availble in SYS.

              BEGIN dbms_scheduler.disable('SYS.TEST'); END;

              *
              ERROR at line 1:
              ORA-27476: "SYS.TEST" does not exist
              ORA-06512: at "SYS.DBMS_ISCHED", line 2763
              ORA-06512: at "SYS.DBMS_SCHEDULER", line 1753
              ORA-06512: at line 1


              Thanks,
              • 4. Re: how to disable dbms jobs?
                670676
                Does exists at DBA_SCHEDULER_JOBS ?

                SELECT JOB_NAME, OWNER, ENABLED FROM DBA_SCHEDULER_JOBS;
                or if you can see it at
                select job,priv_user,schema_user from dba_jobs;
                try then the procedure:
                DBMS_JOB.BROKEN

                Regards,