sql server reporting services: Is there an easy way to do the following?

I have a data load running on a DB/2 mainframe database. When the job
finishes, a message is sent to a Reporting Services system via a text file
that the data load is complete. I’m using SQL Agent to watch for the
creation of the text file and upon creation it starts a RS.EXE job to build a
new SNAPSHOT based on the newly loaded data.

What I want Reporting Services to do upon completion of the SNAPSHOT, which
can take anywhere from 20min to 4 hrs based on the amount of data loaded, is
run a series of reports in order. The problem is there is nothing I can find
that will trigger a report upon the completion of a snapshot creation.

Also, several of the reports have a dependence on a predecessor report. I
can't find any kind of predecessor logic in the RS scheduling.

This logic is easily done in Crystal Enterprise. I’m looking to replace
Crystal Enterprise with RS but I need a clean and easy method to handle
predecessor based scheduling via RS.

--

Hi Kurt,

Admittedly, there is not a easy way to do this, however, if you are calling
the UpdateSnapshot SOAP API, there is an RS event that fires when that is
complete. You can use the event to create subscriptions to it. Use this
option on the subscription pane: When the report content is refreshed. This
option is available only for report snapshots

Check the following article for more informaiton

How to create a file share subscription
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm
/hrs_webui_v1_9jky.asp



Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.