Hey guys,
I have looked through the documentation for a couple days now and searched far and wide on the internet for an answer. I have verified that the user has change notification and all other privileges necessary granted. I made sure the stored procedure that receives the notification works when I run it manually, I registered a query for a test table I created and any change to that table is detected and notification is being sent. So this query select admin_nbr,admin_label,admin_addr from ADMINS gets registered and works properly, but this query Select job_status,program_action from sys.scheduler$_job either won't register using QOS_QUERY telling me it is an unsupported query type or if set to QOS_BEST_EFFORT it will register but changes are not being detected and notifications not sent. I did check to make sure the user has permission to view the sys.scheduler$_job table. I guess I should say a little bit about what I am wanting to accomplish, basically anytime a job starts or stops I want to run a procedure but I don't want to have to set the raise_events attribute for each job individually, so I was trying to use a change to the job_status column to trigger the CQN. So is it just not possible to register queries for system tables or is there another way I need to go about registering it? Or have I got tunnel vision now and missing an easier way to do this?
Thanks!