Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log file in SSRS Expand / Collapse
Author
Message
Posted Thursday, March 27, 2008 2:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 16, 2008 8:27 PM
Points: 6, Visits: 20
hi all....can anybody help me about....how to get the log files when i running the SSRS Data Driven Subscription (any log files, error or success) ?

Thanks :)
Post #475270
Posted Friday, March 28, 2008 3:33 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 5:03 PM
Points: 11, Visits: 581
You can see if Data-Driven subscription was successful by viewing Job Activity, Job History, SQL Server & Windows Logs.
1) Open "MS SQL Server Management Studio" by going to
Start / Programs / MS SQL 2005 / SQL Server Management Studio and go to SQL Server Agent / right-click "Job Activity Monitor" / View Job Activity / right-click any Job / select "View History"
2) From "MS SQL Server Management Studio" go to Management / right-click "SQL Server Logs" / select "View" / "SQL Server Log" / check box "Windows NT"
3) on the Subscriptions tab for report the last "Status" column says something like this "Done: X processed of Y total; Z errors."



Post #476478
Posted Sunday, March 30, 2008 9:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 16, 2008 8:27 PM
Points: 6, Visits: 20
ok....let me check it out....

Thanks dude.... :D
Post #476766
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse