locked
Schedule a Report after Patch Tuesday for Every Month RRS feed

  • Question

  • Hello.

    I need to automate the following process:

    Every month, I need to send a report to the tech team  five (5) days after patch tuesday.

    Every month, I need to send a report to the tech team twelve (12) days after patch tuesday

    How can I create this using SQL Server 2008 R2 and SQL Reporting Services? Is there a way to script this?

    The Scheduling in the GUI-version does not allow to create this "complex" time definitions.

    I cannot use the "Occurs on every second sunday (5 days after patch tuesday)" because on some months, it might be before "every second tuesday".

    Thank you in advance!



    • Edited by SystemJay Monday, February 11, 2013 8:33 AM
    Monday, February 11, 2013 8:33 AM

Answers

  • Hello,

    When we create a subscription schedule on Report Server, a SQL Server job has been created. You can try to edit the schedule in that SQL Server Agent job and make it according to your need.
    Please refer to the following screen shot.

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    • Proposed as answer by Fanny Liu Thursday, February 14, 2013 2:20 AM
    • Marked as answer by Fanny Liu Sunday, February 24, 2013 10:09 AM
    Thursday, February 14, 2013 2:19 AM

All replies

  • Hi,

    Yes you can script it, you can dynamically create or delete subscriptions.

    see here.


    Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

    k r o o t z

    Monday, February 11, 2013 10:30 AM
  • Thank you.

    However, if someone has been dealing with this kind of planning before, I'm also interested in some examples

    of such scripting beside the one article. If there would be more examples or a case related to mine, I would be

    grateful for such URL.

    Monday, February 11, 2013 10:42 AM
  • No one has created this before?

    Schedule reports to occur after a specific event?

    ie. Occurs on every second tuesday every month + 5 days?



    • Edited by SystemJay Tuesday, February 12, 2013 6:06 AM
    Tuesday, February 12, 2013 6:06 AM
  • Hello,

    When we create a subscription schedule on Report Server, a SQL Server job has been created. You can try to edit the schedule in that SQL Server Agent job and make it according to your need.
    Please refer to the following screen shot.

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    • Proposed as answer by Fanny Liu Thursday, February 14, 2013 2:20 AM
    • Marked as answer by Fanny Liu Sunday, February 24, 2013 10:09 AM
    Thursday, February 14, 2013 2:19 AM
  • With the highlighted option, you might set to the Second Saturday.  A problem exists that the Second Saturday isn't always after the Second Tuesday.  Example....the month starts on a Saturday.  Then, Second Tuesday is after the third Saturday.

    You just patched 4 days before Patch Tuesday.

    Seems like the SQL server Agent Scheduler needs extended? 

    Wednesday, March 6, 2013 6:41 PM
  • http://codechurn.wordpress.com/2011/01/21/patch-tuesday-ms-sql-script/

    you can get this script to get the patch tuesday. then use that the  Date add method and get teh necessary date

    Friday, March 8, 2013 4:50 AM