prakashdotc (9/2/2010)
when i incorporate this SP in SQL Agent as a nightly build process it's not working and doesn't sends mail
Are you using the correct profile/account name ? i am sure not
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)