Post reply

Changing @ExecutionTime parameter value in SSRS subscription

  • July 15, 2019 at 3:46 pm

    #3663074

    Hi Everyone,

     

    Can you please guide me how to change @ExecutionTime parameter value in SSRS standard subscription and version is 2012?

    Thanks

    Kanagarajan S

  • July 16, 2019 at 4:10 pm

    #3663505

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • July 16, 2019 at 5:53 pm

    #3663520

    If you are referring to the global variable in SSRS, that's the time the report starts to run so you wouldn't change that. If you want to change the format of that variable, the format is driven by the locale column in the subscriptions table. Or you can use the Format() function.

    Sue

  • July 19, 2019 at 4:59 pm

    #3664591

    If you're taking about changing the SSRS timeout, open your Microsoft Reporting Services Configuration Manager and click on the "Report Manager URL". Click on the URL and then click on Site Settings. The Report Timeout is 1800 seconds by default (1/2 hour). You can specify a different period (3600 seconds for 1 hour) or you can select the "Do not timeout report" option.

  • July 19, 2019 at 10:05 pm

    #3664676

    So what do you really want to do?

    Modify the subscription so it changes when the report is delivered? If so, see the "Schedule" section of this article:

    https://docs.microsoft.com/en-us/sql/reporting-services/lesson-3-defining-a-data-driven-subscription?view=sql-server-2017

Viewing 5 posts - 1 through 4 (of 4 total)

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