Monday, March 12, 2012

HELP !! HELP: Trigger to send REPORT !!!

Hi all,

Report Manager is failing to email out the reports !!!

And... I can not use Report Manager to configure the trigger !

How can I trigger manually to have SQL 2005 email out the reports again?

OR how can I trigger to run those emailing jobs again ?

Thanks,

Frank

I don't really understand the question. How are the subscriptions configured? (Timed or Snapshot?)

If they are configured to fire on a snapshot then you just need to update the report execution snapshot. If they are on a schedule, you could fire the SQL Agent job manually or call FireEvent passing in TimedSubscription and the subscriptionId.

Does that answer your question?

|||

Hi,

Yes, they are "TimedSubscription".

Do you mean to run one of the jobs under "SQL Server Agent"?

and how do I call "FireEvent" passing in TimedSubscription or the subscriptionId?

Thanks,

Frank

|||To trigger an subscription you could make your own small app which uses:
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.fireevent.aspx|||Yes, I meant you could use Sql Server Agent or do as BenniG. Suggested and have an app call the FireEvent method|||

Ok... let's say I want to use SQL Server Agent to run the job that can trigger the Report Manager to email out reports, do you guys have any documents that can show me how to do so?

I checked and ran some jobs under the SQL Server Agent, I don't see anyone of the jobs that were created to email out the reports, if there were no jobs created to do such task, how did those subscriptions email out before they started failing one by one?

Thanks,

Frank

|||

All report server jobs are named as Guids in SQL agent. Every job does essentially the same thing, which is add an event to the Report Server queue. You would need to match up which job created the correct event. If the subscription is to a shared schedule, the schedule ID will be the same as the job name, otherwise the only way to figure it out is find the schedule Id via the RS tables or trial and error.

However the recommened way is to call the FireEvent method.

No comments:

Post a Comment