Post reply

Sending Event Notification service broker messages to remote server

  • July 14, 2009 at 11:47 am

    #133761

    I can capture notifications fine on a the local instance but I want to be able for my services to be able to receive events from other servers. I've set up a service on another server a I can initiate a conversation and send a message but the event notifications will not send to a remote service.

    The event is set up with the SSB guid of the remote service.

    CREATE EVENT NOTIFICATION DDL_EVENTS

    ON SERVER

    FOR DDL_EVENTS

    TO SERVICE 'NotifyService', 'f18c2c64-8810-40f8-9509-a9aada110c42' ;

    The route works.

    CREATE ROUTE NotifyRoute

    WITH SERVICE_NAME = 'NotifyService',

    BROKER_INSTANCE = 'f18c2c64-8810-40f8-9509-a9aada110c42',

    ADDRESS = 'TCP://SV0220SQLMON1:4022';

    I could send the notifications to the local queue and then message them off to the remote service but that seems like an extra step.

  • July 15, 2009 at 2:34 pm

    #1025363

    I figured it out. If any one needs to do this, I can post some scripts. This is really a great way to capture events to a single location.

  • August 6, 2009 at 8:24 am

    #1035390

    Hi ,

    I am trying to the same.

    I want one master server to recieve event notifications from all child servers.

    But it just doesn't seem to work.

    Can you please post some scripts for the same?

    Thanks ,

    Harsh

  • August 6, 2009 at 8:30 am

    #1035405

    I'll put something together for you.

  • August 6, 2009 at 8:38 am

    #1035414

    Do you have anything working?

  • September 2, 2009 at 2:52 pm

    #1048450

    Ben,

    I'd be interested to see any scripts you might have. I'm trying to centralize event collection for a number of servers as well.

    Thanks!

  • September 3, 2009 at 6:55 am

    #1048686

    Matthew Bates (9/2/2009)

    Ben,

    I'd be interested to see any scripts you might have. I'm trying to centralize event collection for a number of servers as well.

    Thanks!

    Do you have service broker working at all?

  • September 3, 2009 at 8:14 am

    #1048764

    Looking forward to seeing the scripts.

  • September 3, 2009 at 9:02 am

    #1048814

    ben.rosato (9/3/2009)

    Matthew Bates (9/2/2009)

    Ben,

    I'd be interested to see any scripts you might have. I'm trying to centralize event collection for a number of servers as well.

    Thanks!

    Do you have service broker working at all?

    Nothing yet. I'm starting from scratch.

  • May 21, 2013 at 2:18 am

    #1616876

    A bit late, I know, but do you have these scripts?

    I'm pretty interested.

    Thanks

  • July 7, 2014 at 7:52 am

    #1727367

    Hi were these scripts ever posted? I am trying to implement the same thing and these scripts would be a big help

    Thanks

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply