Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Sending Event Notification service broker messages to remote server Expand / Collapse
Author
Message
Posted Tuesday, July 14, 2009 11:47 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 4, 2014 7:52 AM
Points: 361, Visits: 1,535
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.


Post #752906
Posted Wednesday, July 15, 2009 2:34 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 4, 2014 7:52 AM
Points: 361, Visits: 1,535
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.
Post #753827
Posted Thursday, August 6, 2009 8:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 17, 2010 9:05 AM
Points: 4, Visits: 46

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
Post #766234
Posted Thursday, August 6, 2009 8:30 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 4, 2014 7:52 AM
Points: 361, Visits: 1,535
I'll put something together for you.
Post #766250
Posted Thursday, August 6, 2009 8:38 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 4, 2014 7:52 AM
Points: 361, Visits: 1,535
Do you have anything working?
Post #766259
Posted Wednesday, September 2, 2009 2:52 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, September 5, 2014 10:13 AM
Points: 817, Visits: 609
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!
Post #781823
Posted Thursday, September 3, 2009 6:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 4, 2014 7:52 AM
Points: 361, Visits: 1,535
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?
Post #782118
Posted Thursday, September 3, 2009 8:14 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:44 PM
Points: 1,207, Visits: 3,191
Looking forward to seeing the scripts.
Post #782207
Posted Thursday, September 3, 2009 9:02 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, September 5, 2014 10:13 AM
Points: 817, Visits: 609
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.
Post #782266
Posted Tuesday, May 21, 2013 2:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 17, 2014 11:47 PM
Points: 15, Visits: 260
A bit late, I know, but do you have these scripts?

I'm pretty interested.

Thanks
Post #1454864
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse