Database Software

Hi,

I have subscribed to SCHEDULER$_EVENT_QUEUE, using dbms_scheduler.add_event_queue_subscriber('user1'); (is an user)

SQL> select consumer_name from dba_queue_subscribers where queue_name = 'SCHEDULER$_EVENT_QUEUE';

CONSUMER_NAME
------------------------------
USER1
SCHEDULER$_EVENT_AGENT

SQL> select OBJECT_NAME, OWNER,STATUS from dba_objects where object_name like '%SCHEDULER$_EVENT_QUEUE%'
01:42:02 2 ;

OBJECT_NAME
--------------------------------------------------------------------------------
OWNER STATUS
------------------------------ -------
SCHEDULER$_EVENT_QUEUE_R
SYS VALID

SCHEDULER$_EVENT_QUEUE_N
SYS VALID

SCHEDULER$_EVENT_QUEUE_
SYS INVALID_

SCHEDULER$_EVENT_QUEUE$23
SYS VALID

SCHEDULER$_EVENT_QUEUE$23
SYS VALID

SCHEDULER$_EVENT_QUEUE
SYS VALID


I am getting invalid status for object SCHEDULER$_EVENT_QUEUE, if i remove event_queue subscriber using

exec dbms_scheduler.remove_event_queue_subscriber('user1) then it becomes valid

What is the real issue why the object SCHEDULER$_EVENT_QUEUE becomes invalid? if i make subscribe, the same become valid on removing.