query on disabling a dbms_refresh job
571299Nov 9 2012 — edited Nov 9 2012Hi all,
We have a 11.2.0.2 windows database running on a Win 2008R2. I am struggling how to kill two duplicate jobs that is auto-enabled & gets created automatically even after using dbms_refresh.destroy. These rouge jobs refreshes the MView every time.
.Need your expert advice how to permanently kill these jobs. Please advise.
Regards,
Job WHAT
-------- ------------------------------------------------------------
4418 dbms_refresh.refresh('"NSG71"."SUCCESSFUL_SUB20121108"');
4419 dbms_refresh.refresh('"NSG71"."SUCCESSFUL_SUBMISSIONS"');
SQL> SELECT refname, refowner, ref_child FROM sys.ku$_refgroup_view;
REFNAME REFOWNER REF_CHILD(REFGROUP, REF_ADD_USER, REF_ADD_DBA)
------------------------------ --------------------------------------------------------------------------------------------------------------
SUCCESSFUL_SUBMISSIONS NSG71 KU$_ADD_SNAP_LIST_T(KU$_ADD_SNAP_T(3944, 'dbms_refresh.add(name=>''"NSG71"."SUCCESSFUL_SUBMISSIONS"'',list=>''"NSG71"."SUCCESSFUL_SUBMISSIONS"'',siteid=>0,export_db=>''DEVNSG'');', 'sys.dbms_irefresh.add(name=>''"NSG71"."SUCCESSFUL_SUBMISSIONS"'',item=>''"NSG71"."SUCCESSFUL_SUBMISSIONS"'',siteid=>0,export_db=>''DEVNSG'
');'))