Post reply

Create SSRS Data Driven Subscriptions on Standard Edition

  • September 2, 2020 at 12:42 pm

    #3785550

    Where do i get the ScheduleID when i execute the main stored procedure.

  • September 2, 2020 at 12:53 pm

    #3785554

    Reyno123 wrote:

    Where do i get the ScheduleID when i execute the main stored procedure.

    I tend to get it from the agent task was created when you created the subscription.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • September 2, 2020 at 1:13 pm

    #3785571

    I haven't created a subscription

  • September 2, 2020 at 1:50 pm

    #3785598

    Reyno123 wrote:

    I haven't created a subscription

    Then you need to. Part of having a "Data Driven" Subscription is having a subscription. The hint is in the name. 😉

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • October 19, 2020 at 8:42 pm

    #3799015

    Hello,

    When I look at the original code, it appears to be in 3 blocks: a split string function at the top of Bernard's post, a proc in the middle of Bernard's post, and then he has some code at the bottom that starts with "Building and Passing through the parameters".

    I'm unclear as to WHERE this last block of code is supposed to reside/be called from.  Is it pasted into the the "Job step properties" window of the SQL Agent task that has the matching scheduleID?

  • January 25, 2022 at 8:27 am

    #3976864

    Thank you so much for this solution.  Helped a lot.

    Is it possible to tweak this solution to also rename the attachment to use report name + current date and not just the subject?

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply