Scheduling Reports

about scheduling a report docid\ wh08aszz 1ncrdijfu5kpscheduling a report docid\ wh08aszz 1ncrdijfu5kpabout reports and daylight savings time docid\ wh08aszz 1ncrdijfu5kp about scheduling a report you can schedule a report to run at specific times in previous releases, the system did not take into account daylight savings time when running scheduled reports this is because the reports use the microsoft ssrs report builder which does not support the daylight savings time offset starting in release 2016 1, we added two time zone fields and the update report schedule dst quick action to account for daylight savings time scheduling a report use this procedure in conjunction with the procedure described in creating reports and report templates docid\ nbwtfjmfn9gmaqcwuo6sm log in to open the reports workspace the system displays a list of reports click the edit icon next to the report to set the scheduling parameters for in the schedule information section, enter the following (you can only select one) option description no schedule does not run the report on a schedule to run the report on a schedule, do not select this option run once on the date to run the report enter a date or select a date from the calendar, then choose a time from the drop down list time zone this field is only enabled if you selected run once on specifies the time zone associated with the date that you entered in the run once on field daily at automatically runs this report every day select a time from the drop down list weekly on automatically runs this report each week select the days for it to run, then choose a time from the drop down list monthly (by week) on automatically runs this report on a specific week each month select the months from the drop down list for example, you could run this report every month or every other month choose the week from the drop down list first second third fourth last choose the day of the week to run the report, and then choose the time of day from the drop down lists monthly (by day) on automatically runs this report on a specific day each month select the months from the drop down list for example, you could run this report every month or every other month enter the number for the day to run the report for example, to run the report on the fourth of every month, enter 4 to run the report on the 5th, 10th and 15th of the month, enter 5, 10, 15 , separated by commas to run the report within a date range, say from the 5th to the 10th, enter 5 10 start the start date all scheduled reports can be designated to start on a specific date select a start date from the calendar, or enter a date into the field end the end date all scheduled reports can be designated to end on a specific date select an end date from the calendar, or enter a date into the field time zone this field is only enabled if you selected daily at , weekly on , monthly (by week) on , or monthly (by day) on specifies the time zone associated with the date that you entered in the daily at , weekly on , monthly (by week) on , or monthly (by day) on fields click save after you run the scheduled report, you can download it from the report center (if you selected download in the distribution information section) or email it (if you selected email in the distribution information section) the schedule status indicates if the report ran successfully and the time when it ran about reports and daylight savings time about daylight savings time docid\ wh08aszz 1ncrdijfu5kpworking with the update report schedule dst quick action docid\ wh08aszz 1ncrdijfu5kp about daylight savings time under certain conditions, reports created while daylight savings time (dst) is in effect might not show events on the correct days to prevent incorrect reporting, ensure that the event time does not occur exactly at midnight (12 00 am) on the day that daylight savings time ends for example, if you specify a date of 4 nov 2012 12 00 am, the record appears on the report as having occurred on november 3 set the event time to something other than midnight (such as 1 00 am) to yield a correct report the following illustrates this concept target times set at midnight on the last day of dst yields an incorrect report set target times to other than midnight (such as 1 00 am) to yield a correct report working with the update report schedule dst quick action to ensure that scheduled reports run at the correct time during daylight savings time, run the update report schedule dst quick action you can either schedule it to run at certain intervals, such as daily or monthly, or you can manually run it any time when daylight savings time happens, the schedule shifts and the system runs the report at the correct time for this quick action to run correctly, you must enter a value other than your local time in either of the time zone fields; that is, you must select a specific time zone for the report schedule follow the steps below to manually run the update report schedule dst quick action log in to open the notification workspace from the action menu, select no category > update report schedule dst the system runs the update report schedule dst quick action