Tuesday, February 14, 2012

Customizing Subscription Maintenance

I would like to use my own subscription setup screens, but am having a little
trouble. I basically need to be able to grab a report and schedule it. As
far as I can tell, I think I only need the following tables:
ReportServer.dbo.Schedule, ReportServer.dbo.Subscriptions,
ReportServer.dbo.ReportSchedule w/ the corresponding Stored Procs CreateTask,
CreateSubscription, AddReportSchedule, respectively. I also need the
following from msdb: sysjobs, sysjobsteps, sysjobschedules. I've worked w/
the msdb tables before and have automated the process of creating scheduled
jobs, but am a noob when trying to do the same w/ the ReportServer db tables.
Is there any documentation out there on customizing these schedules (e.g.,
how the scheduleid or subscriptionid is created)?Ok...I don't think that it is possible to get around this one. Anyone have
any luck / information on doing what I want (see previous post).
What about customizing the screens then? All I want the user to be able to
see and have the ability to do is create and modify subscriptions for reports.
"Neo" wrote:
> I would like to use my own subscription setup screens, but am having a little
> trouble. I basically need to be able to grab a report and schedule it. As
> far as I can tell, I think I only need the following tables:
> ReportServer.dbo.Schedule, ReportServer.dbo.Subscriptions,
> ReportServer.dbo.ReportSchedule w/ the corresponding Stored Procs CreateTask,
> CreateSubscription, AddReportSchedule, respectively. I also need the
> following from msdb: sysjobs, sysjobsteps, sysjobschedules. I've worked w/
> the msdb tables before and have automated the process of creating scheduled
> jobs, but am a noob when trying to do the same w/ the ReportServer db tables.
>
> Is there any documentation out there on customizing these schedules (e.g.,
> how the scheduleid or subscriptionid is created)?
>

No comments:

Post a Comment