Hi

Can anyone help me how to send out a mail notification to a user whose name is present in the table using a stored procedure? I need to run this stored procedure every monday so that it will check the database and send mail to those people to whom mail has to be sent according to the conditions specified in the stored Procedure.

All help appreciated.

Thanks and regards,
Anoop

run the Stored-Proc inside a Shell-script schedulled in CRON/AUTOSYS. Let the Stored-Proc return the "USER-NAMES" as OUTPUT parameters and assign them as variable USER_NAME. Take them one by one in a WHILE or FOR Loop and run the unix/linux MAIL TO command with the variable $USER_NAME as the EMAIL_ID and send the mail one after another.

Or you write a stored procedure in C/C++ or Java to compose the email and use a system call for the actual sending.

Thank you for the quick reply.

I am working on Windows and am sorry for not mentioning it before. I would like to know if there is any way by which we can send a mail from the Stored Procedure and invoke this every Monday automatically. Please get back if you are not clear on my requirement.

Thanks and Regards,
Anoop

Which email software do you have on your system with a non-interactive interface? Do you connect to a POP or IMAP server?

You can write in java / C /C++ / ASP script to send the mail.... other than that i am not 100% sure whether you'll be able to send a mail only with the SQL stored proc...

As for invoking you can use the following scenarios -
[1] Use DB2 Task Center to schedule the job
[2] Write a bat file to invoke the script and schedule the same in schedule task option of windows.