Monday, January 30, 2012

How to enable and disable ALL Jobs in ORACLE

u can use this query to disable or enable all jobs except EXFSYS,ORACLE_OCM,SYS.. u can simply chose in which owners should be not by adding user names at the end of script...

TO DISABLE
TO ENABLE


just run outputs...
Posted by at

3 comments:

  1. UnknownNovember 24, 2014 at 2:10 AM

    It's nice blog for oracle updates , Anantha.co.uk, one of the UK's leading technology Oracle recruitment agencies.Feel free, contact to us now.

    ReplyDelete
  2. SantoshApril 8, 2018 at 1:25 PM

    Thanks for sharing. One can easily enable/disable a scheduled job

    ReplyDelete
  3. AnonymousMay 25, 2018 at 8:00 AM

    Super scripts

    ReplyDelete

Subscribe to: Post Comments (Atom)