NF10 Tenant Time Zone For Cron Scheduler

From iDempiere en

Feature: Tenant Time Zone for Cron Scheduler

Goal: Functional

Developer: Hengsin (talk)

Feature Ticket: IDEMPIERE-5093

Add option to support the scheduling of cron pattern scheduler with tenant time zone instead of server time zone.


  • Added Timestamp With Time Zone data type reference.

Timestamp With Time Zone

  • Added example usage at Test window. The field uses tenant time zone if set, otherwise it falls back to the detected browser time zone. There's suggestion to add user level time zone preference but that's not implemented in this ticket.

Timestamp With Time Zone Field

  • Added Time Zone data type reference. It is a text data type to store Time Zone id.

Time Zone data type reference

  • Context Menu for Time Zone field. The context menu will show the auto detected browser time zone id.

Time Zone field context menu

  • Drop down list for Time Zone field show the list of all supported standard Time Zone ids. User can also choose to enter custom Time Zone id in the format of GMT<+/-><hour offset>:<minute offset> (for e.g GMT+03:00).

Time Zone field Drop Down List

  • Added time zone field to Tenant Info (AD_ClientInfo.TimeZone). When set, cron scheduler will use this instead of server time zone.

Tenant Info Time Zone field

  • Change AD_Scheduler.DateLastRun and AD_Scheduler.DateNextRun column to Timestamp With Time Zone type.

Scheduler timestamp with time zone fields

  • Added #clientInfo_timeZone environment context - store the auto detected browser time zone id

Change on Schedule behaviour

Before this ticket when you had a schedule configured to run at 9AM, the job was executed at 9AM of the server timezone.

This ticket changed this behavior and now the job is executed at 9AM of the tenant timezone where the job is defined.

Cookies help us deliver our services. By using our services, you agree to our use of cookies.