Sql server Job monitoring

vs_parab

Hi,

I am trying to create sql server - sql server user experience monitor which returns me the Name of failed job. I have written query to get the name of failed job from msdb database. however while testing i get following msg.

The server SVR001 is clustered.

'' Testing on node SVR001: failed with 'NotAvailable' status
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)  "

Is there any other way by which I can name of failed job?

Thanks in advance

Vishnu

qle

Based on the description and searching on the error message, the problem seems to stem from the fact that either

1. SVR001 isn't setup for remote SQL connections from the NPM poller or,
2. the SQL Server instance specified in the User Experience monitor doesn't exist on SVR001

Have you tried connecting and running the query from the NPM poller yourself?