1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

DBMS_SCHEDULER in RAC environment

Discussion in 'Server Administration and Options' started by prashant, Aug 8, 2011.

  1. prashant

    prashant Forum Advisor

    Messages:
    85
    Likes Received:
    7
    Trophy Points:
    160
    Location:
    New Delhi, India
    Hi,

    Do we have an option to hard code a scheduler job in such a way that it always runs on a particular node in n-node RAC?

    Also, is it possible to pause a running scheduler job and resume on another node?

    I am looking for these answers on both 10.2.0.4 & 11.2.0.1 releases (Solaris Sparc-64 bit)

    Thanks in advance.

    Best Regards,
    Prashant
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO