Re: DBMS_SCHEDULER and snapshot standby
From: Sanjay Madan <madan.sanjay_at_gmail.com>
Date: Wed, 14 Aug 2013 14:28:02 +0530
Message-ID: <CAH8+-2AAvyio12hHjmvFd0cFDGprgfwpB7U_SqcWF8RWV3gKPA_at_mail.gmail.com>
Nial
The jobs havnt disappeared I think. The view user_schedular_jobs, for some reason , has " database_role = 'PRIMARY' " explicitly mentioned. That causes the jobs not to get picked up by the view. As a workaround, we created a view where we removed that database_role condition. The pain is that everytime we enable the cascade, we need to recreate this manual view.
Date: Wed, 14 Aug 2013 14:28:02 +0530
Message-ID: <CAH8+-2AAvyio12hHjmvFd0cFDGprgfwpB7U_SqcWF8RWV3gKPA_at_mail.gmail.com>
Nial
The jobs havnt disappeared I think. The view user_schedular_jobs, for some reason , has " database_role = 'PRIMARY' " explicitly mentioned. That causes the jobs not to get picked up by the view. As a workaround, we created a view where we removed that database_role condition. The pain is that everytime we enable the cascade, we need to recreate this manual view.
The jobs actually fire on schedule. They are just not displayed.
Sanjay
On Thu, Aug 8, 2013 at 3:34 PM, Niall Litchfield <niall.litchfield_at_gmail.com
> wrote:
> Hi list
> While I wait for support's answer on this, does anyone know if
> dbms_scheduler is supported in a snapshot standby database. All of our jobs
> have disappeared and we can't apparently create new ones.
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 14 2013 - 10:58:02 CEST