Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How can"Transaction Log Shipping status" report on Management Studio be subscribed to mailIDs. Expand / Collapse
Posted Tuesday, March 10, 2009 3:06 AM

Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 14, 2009 11:31 PM
Points: 61, Visits: 191
Hi All,

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.

Post #672227
Posted Tuesday, March 10, 2009 3:51 AM



Group: General Forum Members
Last Login: Tuesday, April 26, 2016 11:13 AM
Points: 2,056, Visits: 3,650
Well, I thought this would be a bit easier than it probably will be. The report file itself must be embedded in the actual application as I couldn't find it on the drive in what I would consider to be the standard locations. Based on Books Online it calls sp_help_logshipping_monitor stored procedure so, you should be able to use that to quickly develop a report in reporting services so that you can send it out via email daily as you are required.

I don't know of any way to schedule the standard reports for distribution outside of getting them in reporting services.

Hope this helps.



“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Post #672243
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse