I have a report which uses database command to get data from more than one SQL Server. It union all data and generate the repots.

The report is scheduled to run automatically in CMC and it runs fine in normal case.

The problem is if any of the server connection fails, the report fails.

Is there any way to run the report after getting data from the available servers and ignore the fail server.
I want something through which I can check whether a particular server is down or up at the report time.
Remember the report is scheduled to run automatic without any user input.