Our biz system uses SQL Server 2005 a the back end.
We would like to automatically email a link to a web survey to certain customers when there order completes.
The trigger in the database would be an invoice being generated (means the job is complete in our process.)
Can a SQL Server job be built to send an email such as this? Can anyone point me to some info on creating these? Thanks!