trigger a mail when table data is updated in sql server by using the ssrs report

Question

User-775001650 posted

Hi friends,

          i want to genarate a report and trigger a email based on any change will occured in table data in sql server. Is there any better way to do this by using ssrs report.

thanks.

Answer 1

User-830258159 posted

Try SSIS instead.

Answer 2

User88744855 posted

you can configure sql server mail and from trigger invoke that mail. so just search google for sql server mail configuration and send syntax.

Answer 3

User-775001650 posted

I am done this requierment like i created ssrs report and created a subscription , it will created the subscript job id in SQL Server Agent, i created one trigger on that table  and excuted when data change is occured in data table. In that trigger i call the below line of code.

  exec sp start job 'sbscription job id here'

thanks