Thanks for the feedback, that is kind of what I had expected, thank you for the clarification.

Thanks for the options, I did check the browser service and it's running on both the UCP and hte managed instance. I think there may be an issue with...

Does it need to be in HTML format? Have you tried emailing it as a PDF/EXCEL file and then viewing the report?

thansk for the responses: this is what I ended up doing and it returned exactly what I was looking for.

SELECT --@@SERVERNAME,

...

We have a very similar environment and one of our clustered nodes went down and we tried to restart the sql service and the service continually failed , with whatever...

I already know what to query in order to get the information I need (completion time for the related job)

however using the code below (standard email notification) I am...

We are already doing that with the alert/operator function. I am definitely looking for a more granular approach/solution. I know i could run a query against the msdb...

Yes, that is correct.

Have you checked to make sure that Allow Remote connections to this server was enabled, and Require distributed transactions was checked off on server to server communication?

Right click the...