CODEWITHSUNDEEP
sqlsql-serverreporting-servicessql-server-2008-r2
user2671286
user2671286

Reputation: 101

Schedule SSRS task

I want to schedule two reports, one report to be triggered on the last working day of the month. Another report to be triggered on the first workday of the each month. How can I do this?

Upvotes: 0

Views: 84

Answers (2)

Sébastien Sevrin
Sébastien Sevrin

Reputation: 5405

There are currently no ways to do this through the standard subscription mechanism.

Your requirements are not only conflicting with the UI (the ReportServer website), but with the Reporting Services database design. You can take a look at the Schedules table to see what I mean.

There are 3 things you could do:

  1. Fast & Risky, not recommended
    Edit the generated SQL job (never tested and not supported), here you can specify weekdays. Schedule

  2. Good approach but (very) long term
    Submit a connect suggestion.

  3. Recommended but needs development
    Develop an application that consume the Reporting Services webservice and has a tailored subscription mechanism.

You could consider doing step 2 & 3.

Upvotes: 1

Trubs
Trubs

Reputation: 3042

a subscription on the first day of the month is pretty easy. Whether data driven or static the schedule you set up can be set to run on the first day of every month. enter image description here

For the last day of every month, you'll need to create 3 subscriptions. One subscription for September, April, June and November (on calendar day(s) = 30), one for all the rest (on calendar day(s) = 31), and one for February alone (on calendar day(s) = 28).

Leap years.... you're on your own there...

Upvotes: 0

Related Questions