SQL Server can be monitoring with SSIS packages using the DMVs in SQL Server. I did a webinar on this and you can watch the video at PragmaticWorks.com under the webinars page.
You can download the code for this webinar here.
I have updated the script. I removed the BIxPress compoents and included the date script. I have tested and it runs great.