Automated Trigger a SSRS Subscription

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Automated Trigger a SSRS Subscription

Automated Trigger a SSRS Subscription

Rate Topic

Display Mode

Topic Options

Author

Message

Mac1986

Posted Thursday, November 15, 2012 12:12 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 4:07 AM
Points: 180, Visits: 516

Hi All,
i have requirement here to trigger a SSRS report as soon as our ETL Jobs are completed. I have created the SSRS Report and subscribed it. Now my manager wantes to see an email as soon as the ETL process is completed.

I understand I can write a HTML Script for a simple email. But the emails should have bunch of other lines and stakeholder's names and our Team policies and stuff with fancy, decorative colours and pics.. Thats why I made a SSRS report for his satisfaction and now I got more stuck when he asked me to a automate this subscription.

is there way to fire a Subscription.. I need to deliver it soon..

Post #1384991

Paul Smith-221741

Posted Friday, November 16, 2012 10:39 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, June 10, 2013 6:55 AM
Points: 427, Visits: 278

Simplest Way - Include an HTML Link to the report in the email

Post #1385784

« Prev Topic | Next Topic »

Permissions