I've written an SP that scans a database and sends out alerts as an email and net send messages. It works fine if I execute it through SQL Query Analyzer. But if I create a job in SQL Agent as 'exec xsp_SP' and schedule it to run every 10 mins, I receive email alerts but not net send messages. Why is that? Also, how do I specify an operator's email address/net send address in my SP? Can I send messages to multiple operators?
Thanks in advance,