Hi all,
I am trying to use 'Windows Service Monitor' to monitor 'SQL Integration Services' (all versions).
The hosts that I have to monitor have different versions of Integration Services running on those.
So the service name could be MsDtsServer100/MsDtsServer110/MsDtsServer120/MsDtsServer130
Is there any way I can monitor this service without first knowing which host is running which version?
Something like what we do in SQL - ServiceName LIKE 'MsDtsServer1%'
I know in the 'Windows Service Monitor' we have to provide exact service name, but is there any way to do this using 'Windows Service Monitor' or any other monitor?
How are you guys monitoring this service?
I am trying to avoid creating 4 different 'Windows Service Monitors' for each version of Integration service as the bigger paint there is to first find out which host is running which version.