I am not sure if I am in the right group.
I am trying to do the following on SQL 2005
- Email completion alerts from our maintenance jobs.
- Email task from SSIS tasks.
I have Database Mail running within Management Studio
I performed a test Email (Database Mail) and I got it.
I performed a telnet mailserver 25 test and I got it.
I have a receiver connection with the IP address of the SQL server on my mailserver.
I edited a maintenance job and setup an Email alert within the Notifications.
I run the job and I don't get Email alert (when the job completes)
Any ideas?
Thanks