February 26, 2009 at 10:03 pm
Hi All,
How can we know when a queue gets disabled. I need to set up an alert that sends message when queue gets disabled. How can i achieve this.
Thanks in advance
February 27, 2009 at 9:32 pm
I don't know of any feature of Queues that would do that for you. I think your best bet would be to write a proc to monitor it once a minute or so and then submit that as an Agent Job.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 28, 2009 at 6:04 am
Sqlserver raises events when a queue get disabled.
Check out "CREATE EVENT NOTIFICATION" in books online !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 28, 2009 at 7:22 am
Great catch Alz! I forgot to check that... :blush:
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply