I am looking for either a solution to this problem or some ideas on how to debug.
I have a website that calls a cobol executable. This occurs on the application server. The cobol exe connects to a database on another server using an ODBC connection. The cobol exe, after generating a report, deletes a row from a table in the database and should then execute a stored procedure which uses db mail to notify the user that it is finished.
The report is generated without error and the correct row of the database table is deleted. Unfortunately the email is never received.
I have taken the following action:
1.Ran the stored procedure that uses db mail using enterprise manager and received an email as expected.
2.Checked the db mail log for errors of which there are none.
Any help is appreciated.