sql server reporting services: Generate Executed Subscriptions Report. -- sql server reporting services

You're in the

sql server reporting services

group:

Generate Executed Subscriptions Report.

Generate Executed Subscriptions Report.

Carlos E. Mosquera
9/27/2004 4:47:03 PM

sql server reporting services:

Hi

Now i need a report of executed subscriptions in specific shared schedules,

Someone have something to parse Subscriptions table or only way is consuming
webservice???

Someone have an idea???

I program a module to get subscriptions (with lastexecution, emails, report
name, etc.) but i need a report.
--
Carlos E. Mosquera
DBA - Project Manager

Re: Generate Executed Subscriptions Report.

RK Balaji
9/27/2004 9:33:24 PM

There is a RSExecution DTS Package under tools that comes with SQL Reporting
services.. Have you looked into it..?

"Carlos E. Mosquera" <CarlosEMosquera@discussions.microsoft.com> wrote in
message news:9940F556-770B-4DD4-8C73-BDF4F2B263CC@microsoft.com...
[quoted text, click to view]

Re: Generate Executed Subscriptions Report.

Carlos E. Mosquera
9/28/2004 8:29:07 AM

Hi RK,

Where i can find info about this tool???

Thanks for you help.

[quoted text, click to view]

Re: Generate Executed Subscriptions Report.

Carlos E. Mosquera
9/28/2004 8:57:02 AM

Hi RK,

Where i can find info about this tool???

Thanks for you help.

[quoted text, click to view]

Re: Generate Executed Subscriptions Report.

RK Balaji
9/28/2004 6:09:21 PM

It is under this following directory (assuming your install path is on the c:\ drive)

C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\ExecutionLog

You need to create the RSExecutionLog database on the SQL server and run the createtables.sql to create required tables. Once that is complete, import the rsexecutionlog_update.dts into DTS on SQL Server and execute it. You can schedule this package to run couple of times a day to automatically upload log data into this database.

Hope this helps.

RK

nntp://news.microsoft.com/microsoft.public.sqlserver.reportingsvcs/<6A57FE0F-F9B7-4646-955D-A6F90BEECB21@microsoft.com>

Hi RK,

Where i can find info about this tool???

Thanks for you help.

[quoted text, click to view]

[microsoft.public.sqlserver.reportingsvcs]

Re: Generate Executed Subscriptions Report.

Carlos E. Mosquera
10/7/2004 7:23:04 AM

Hi all,

Someone know about this RSExecution DTS Package???

Thanks.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn