This article is to clarify the use of "Run as tz" field on the Scheduled Job [sysauto] table and tables extending from this table such as Scheduled Data Collection [sysauto_pa], Scheduled Email of Report [sysauto_report] and Scheduled Data Import [scheduled_data_import]. You may need to configure the form to display this "Run as tz" field.
1. The value specified in the "Run as tz" field will apply to the queries where dates and relative date functions are specified when the job runs. It is not related to the Time specified (the time when the job will execute) for the record.
2. The default value for "Run as tz" will be the Time zone specified in the user profile of the user specified in the "Run as" field (which will default to the user who creates this job). However, if you would like the job under a different timezone, you can manually select the timezone in the "Run as tz" field.
3. If dates and/or relative date functions (such as Yesterday) are used in the job, the values of these dates will be with respect to the chosen timezone.
4. To illustrate this, please consider the following Scheduled job (the Time zone of the user: System Administrator is GMT).
5. When the job runs, the result of line 4 will be as follows:
Test TZ Date:
Date: 2019-10-17 02:00:00
6. If the timezone: US/Pacific is selected for "Run as tz" (as follows), the result will be changed to reflect the time as per US/Pacific timezone.
Test TZ Date:
Date: 2019-10-16 19:00:00
7. Please see the screenshot below for the results when the different timezones are selected.
8. From the Orlando release onwards, when you create a job, you will be able to select the Time Zone (using the "Time Zone" field) and specify the time at which the scheduled job will run. For more information on the Time Zone field, please refer to the documentation on Automatically run a script of your choosing.