I had a stored procedure written to send mails using DB mail feature.
since yest i hav been continuously getting mails and not able to figure out
where the problem lies. If the procedure is getting executed continuously or
if any other such query is running how do i get to knw and stop it.
Try adding more detail like Job Name, etc. to your email.
Is this SP being triggered by some action on a database table?
can you provide more details on this?