fesnyng
asked on
Scheduling Subscriptions with SSRS
I need to schedule Report subscriptions (email) every half hour for specific work hours of the day (ex: 6am through midnight). In the world of Blackberry's, emails are instantly available AND the execs do not want to receive these subscriptions from midnight through 6am.
SSRS does not appear to have a Start Time and End Time capability. The brute force workaround is to create a subscription for each time period. For a 6am through midnight work day that would be 36 subscriptions,
Is there any work around (or SSRS feature not yet found) that will save us from creating multiple reports with up to 36 subscriptions each?
SSRS does not appear to have a Start Time and End Time capability. The brute force workaround is to create a subscription for each time period. For a 6am through midnight work day that would be 36 subscriptions,
Is there any work around (or SSRS feature not yet found) that will save us from creating multiple reports with up to 36 subscriptions each?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>can located in a table in the ReportServer database but I cannot recall exact tables.
see code snippet below. Change the WHERE clause as needed to locate the exact report.
see code snippet below. Change the WHERE clause as needed to locate the exact report.
SELECT sch.ScheduleId, sub.[Description]
FROM dbo.Subscriptions sub
INNER JOIN dbo.Schedule sch ON sub.SubscriptionId = sch.[EventData]
WHERE sub.LastRunTime IS NULL
ASKER
PERFECT. Thanks for the step by step.
http://stackoverflow.com/questions/374982/custom-timed-subscription-schedules-in-ssrs