Below is the code I am using just to try and get the notification into the queue (After that My plan was to send an email to myself with an alert of some sort.)
--Create a queue to receive messages.
CREATE QUEUE pmNotifyQueue ;
--Create a service on the queue that references
--the event notifications contract.
CREATE SERVICE pmNotifyService
ON QUEUE pmNotifyQueue
--Create the event notification.
CREATE EVENT NOTIFICATION pmQueueDisabled
TO SERVICE 'pmNotifyService', 'current database';
The error I get is :
Msg 1098, Level 15, State 1, Line 2
The specified event type(s) is/are not valid on the specified target object.
This error is from the CREATE EVENT NOTIFICATION step.
I can;t figure it out - Any Suggestions?