I am trying to use Scheduler sniper sample that I found on the web that I am having problems creating the job.
I log in as RMSADM that has been granted DBA privileges. On the call to dbms_scheduler.create_job I get error "ORA-27375: valid agent name must be specified for secure queues".
Searching for help on this says you have to be subscribed and have appropriate privileges. It looks like I do and I can't figure out why I am getting this error.

Any help would be greatly appreciated.

I am using Oracle 11gR2.

Thank You,
Mark



-- add an event queue subscriber for this user's messages
begin
dbms_scheduler.add_event_queue_subscriber;
end;

PL/SQL procedure successfully completed

-- create sniper procedure
create or replace procedure RMS_Scheduler_Sniper_Proc( message IN sys.scheduler$_event_info ) as
begin
-- if this is not a JOB_OVER_MAX_DUR message, error out
if message.object_owner!='RMSADM' or message.event_type!='JOB_OVER_MAX_DUR' then
raise PROGRAM_ERROR;
end if;

-- stop the job
dbms_scheduler.stop_job( job_name =>'"'||message.object_owner||'"."'||message.object_name ||'"', force=>true );
end;

Procedure created

-- create sniper program
begin
dbms_scheduler.create_program( program_name => 'RMS_Scheduler_Sniper_Prog', program_action => 'RMS_Scheduler_Sniper_Proc', program_type => 'stored_procedure', number_of_arguments => 1, enabled => FALSE);
dbms_scheduler.define_metadata_argument ( 'RMS_Scheduler_Sniper_Prog','event_message',1);
dbms_scheduler.enable('RMS_Scheduler_Sniper_Prog');
end;

PL/SQL procedure successfully completed

grant create job to rmsadm

Grant succeeded

-- create a general purpose sniper job to kill any job that has exceeded its max_run_duration
begin
dbms_scheduler.create_job( job_name => 'RMS_Scheduler_Sniper_Job', program_name => 'RMS_Scheduler_Sniper_Prog', event_condition => 'tab.user_data.event_type = ''JOB_OVER_MAX_DUR''', queue_spec => 'sys.scheduler$_event_queue,myagent', enabled => true);
end;

ORA-27375: valid agent name must be specified for secure queues
ORA-06512: at "SYS.DBMS_ISCHED", line 124
ORA-06512: at "SYS.DBMS_SCHEDULER", line 457
ORA-06512: at line 3





select * from SYS.SCHEDULER$_EVTQ_SUB

AGT_NAME UNAME
------------------------------ ------------------------------
RMSADM RMSADM

1 row selected

select * from DBA_AQ_AGENTS

AGENT_NAME HTTP_ENABLED SMTP_ENABLED
------------------------------ ------------ ------------
SCHEDULER$_EVENT_AGENT NO NO
SCHEDULER$_REMDB_AGENT NO NO
SERVER_ALERT NO NO
HAE_SUB NO NO
NGWPC_RMS_DB_1830_J3RMS9P1 NO NO
NGWPC_RMS_DB_1830_IJ3RMS9P1 NO NO
RMSADM NO NO

7 rows selected

select * from DBA_AQ_AGENT_PRIVS

AGENT_NAME DB_USERNAME HTTP_ENABLED SMTP_ENABLED
------------------------------ ------------------------------ ------------ ------------
NGWPC_RMS_DB_1830_IJ3RMS9P1 SYS NO NO
NGWPC_RMS_DB_1830_J3RMS9P1 SYS NO NO
RMSADM RMSADM NO NO
SCHEDULER$_EVENT_AGENT SYS NO NO
SCHEDULER$_REMDB_AGENT SYS NO NO
SERVER_ALERT SYS NO NO
HAE_SUB NO NO

7 rows selected