Dale Turley (1/28/2010)

---

First off - great article and a really handy stored procedure..

When i executed the sp i got this error message

Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 72
An INSERT EXEC statement cannot be nested.
Msg 242, Level 16, State 3, Procedure uspEmailSQLServerHealth, Line 126
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

It did send me an email though so all's good.

exec EmailSQLServerHealth '10.10.10.10', 'MYProject', 'myself@mycompany.com', 'TestMailProfile', 'My Self'

exec uspEmailSQLServerHealth '10.10.10.10', 'MYProject', 'myself@mycompany.com', 'TestMailProfile', 'My Self'