Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Sending mail through stored procedure
i am working in sql server 2000.
i have created stored procedure to send mail which is working fine.
but as per requirement user can import data from front end i.e. from asp.net page from excel file to sql server database like user name and password into login table. whenever new login is created mail should fire. Now my query is how to create a job to send mail or to execute that stored procedure.
Any help is greatly appreciated
Keep smiling :-)