Here's the stored proc I use, I put it in the master database and then call it from a VB app. I'm sure you could get a developer to help...

I use the SQL Distributed Management Objects in a stored proc to get the status of SQL Agent and have the stored proc email me if the status is anything...