I'm trying to export or publish one of the standard reports included with SQL 2005... I've got two SQL servers configured and they are running log shipping from one to the other. This runs well and i can manually view the "Transaction Log Shipping status" report in SQL server management studio.
What I want to do is this report should be emailed to a user everyday so they we can monitor this ourselves.
can i have step by step instructions on either scheduling an export of this report or publishing it, I have reporting services installed.
How can this be subscribed.