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 :-)