December 3, 2010 at 9:13 am
Hi,
How can I know that the reporting service is down?
I need receive a notification by a email....
Thanks,
December 3, 2010 at 10:54 am
I guess it all depends on what you mean by the reporting service is down...
you could write something with powershell, wmi, [insert your scripting language of choice] to check to see if the SQL Server Reporting Services([SQL instancename]) is started. Then you'd schedule that as a job and set it to email you if it's not started.
Additionally, you could use MOM (Microsoft Operatoins Manager), IBM's Tivoli, HP's Openview to accomplish the same thing.
I actually use a product called Server's Alive[/url] which does the above, but also has the ability to query a webpage and check for the existence of certain words. This is the way I check my SSRS instances. I check for the heading to display certain words, if it doesn't it throws an error and emails me. It checks once every 15 minutes, but that can be configured however you want it to be.
-Luke.
December 20, 2010 at 9:58 am
You might need use a windows jobs to check every few seconds if the service is up or not!!
There isn't any other easy way to check this.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply