none
Time Zone & Subscriptions RRS feed

  • Question

  • Hi,

    I'm working with SSRS integrated in Sharepoint2010 and we use "Subscriptions". The website Time zone is "(UTC-6) Central Time (US & Canada)".

    But we have users based in Paris, so to schedule theri reports they  must "translate" their business time into the Time zone defined on the site part !

    So during the lastest week we had some issues about reports scheduling, beause US changedd the local daylight time one week after European countries

    (the 28th of October for Paris, the 4th of November for Houston)

    Is there a notion a "User Time" or something equivalent ?

    The key point is how to not modify each subscriptions on each "time change" ?

    Thanks in advance for your help.

    Regards

    Bohor

    Paris :http://www.timeanddate.com/worldclock/clockchange.html?n=104

    Houston :http://www.timeanddate.com/worldclock/clockchange.html?n=195


    • Edited by Bohor Tuesday, November 6, 2012 9:22 AM
    Tuesday, November 6, 2012 9:22 AM

Answers

  • Hi,

    I understand...

    So, what I'd suggest is :

    Create separate subscriptions based on timezone AND report.

    So a given report will be sent from different subscriptions depending on which timezone its users are located.

    Given that SSRS Subscriptions are actually implemented as SQL Server Agent jobs, you can change a report schedule by manipulating its

    underlying SQL Server Agent job.

    Therefore, you can write jobs (one per timezone) that will adjust reporting schedules according to DST/EST changes.

    For example, North American SSRS schedule will be altered on the first Sunday of November and the second Sunday of March.


    Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu


    • Edited by Sebastian Sajaroff Tuesday, November 6, 2012 1:29 PM
    • Proposed as answer by Mike YinModerator Wednesday, November 7, 2012 10:47 AM
    • Marked as answer by Bohor Wednesday, November 7, 2012 11:51 AM
    Tuesday, November 6, 2012 1:29 PM

All replies

  • Hi,

    I can think of two choices : either configure one SSRS box per timezone or configure all your servers to run on UTC timezone (Universal Time Zone, formerly known as Greenwich Mean Time).


    Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

    Tuesday, November 6, 2012 1:10 PM
  • Hi Sebastian

    thanks a lot for your help.

    • one SSRS Box per timezone: in native mode maybe, but in integrated mode it's not possible
    •  UTC timezone, but we'll still have the problem the next change hour.

    I explain our business process :

    End-users update data each monday morning before 9:15 AM (business hours)

    At 9:30 AM a reports is sent !! (the reports must be received before 10:00 AM !! -> a weekly meeting at Paris)

    So if I do not change manually the clock of the schedule the reports could be received to late or too early :-(

    regards

    Tuesday, November 6, 2012 1:21 PM
  • Hi,

    I understand...

    So, what I'd suggest is :

    Create separate subscriptions based on timezone AND report.

    So a given report will be sent from different subscriptions depending on which timezone its users are located.

    Given that SSRS Subscriptions are actually implemented as SQL Server Agent jobs, you can change a report schedule by manipulating its

    underlying SQL Server Agent job.

    Therefore, you can write jobs (one per timezone) that will adjust reporting schedules according to DST/EST changes.

    For example, North American SSRS schedule will be altered on the first Sunday of November and the second Sunday of March.


    Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu


    • Edited by Sebastian Sajaroff Tuesday, November 6, 2012 1:29 PM
    • Proposed as answer by Mike YinModerator Wednesday, November 7, 2012 10:47 AM
    • Marked as answer by Bohor Wednesday, November 7, 2012 11:51 AM
    Tuesday, November 6, 2012 1:29 PM