reporting services - SSRS Report to run based on an event -


here scenario user wants... etl completed @ 5 , row inserted in table upon successful load. starting @ 5 ssrs report should row inserted, every 30 seconds. when sees row inserted , ssrs report should run in turn sends email users specified in subscription.

is there way achieve without sql -rd? please give me direction new msbi.

regards, chakrapani m

it's not ideal solution, if you're running enterprise edition, set data driven subscription check inserted row, , if it's present, return list of email addresses - use returned value populate "to:" field in data driven subscription. if no data present, no email addresses returned, , subscription "fail".

alternatively, if have access so, find job subscription creates on ssrs sql host, , alter add necessary conditional logic run subscription when appropriate.


Comments

Popular posts from this blog

javascript - How to name a jQuery function to make a browser's back button work? -

python - Django-easy-pdf: xhtml2pdf reporting reportlab 2.2+ is required, but 3.0 installed -

collision detection - C++ library for mesh to mesh intersection: what is available? -