Jobs Scheduling through Crontab - Days of Week shift every time the job is submitted

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Every time a job is resubmitted, the CRONTAB scheduled Days of Week shift unexpectedly. 

Steps to Reproduce: 

1. Navigate to Home, Reports and Jobs. Click on the "Jobs" tab 
2. Filter for "Post Timesheets" job, click on it, and do the following: 
   1. Change "Job Name" to "Testing" 
   2. "When" = "Scheduled" 
   3. "Start Date" and "Start Time" to be set to the future 
   4. Click on "Set Recurrence"
      1. Click on "Use UNIX crontab entry format" 
      2. Populate with "0 12 * * 1,2,3,4,5" 
      3. Save and Return 
   5. Submit 
3. Click on the job from step 2 again. Do no change. Submit again 
4. Open the job for a third time, and click on "Set Recurrence" again 

Expected Results: The Crontab's value is set to "0 12 * * 1,2,3,4,5". 

Actual Results: The Crontab's value has changed to "0 12 * * 3,4,5,6,0". 

Environment

Release : 15.9.3, 16.0.0, 16.0.1, 160.2 

Component : Clarity Scheduler

Cause

DE63797 

The issue lies with the time zone of server and time zone of User that's set in Account Settings. If both the time zones are 12 hours apart then we will see this issue. 

Ex :- User time zone is IST and server time zone is PST.

1. When user first submits the CRON, the value is stored correct in the DB in DB timezone. 
2. When user opens up the CRON again, value displayed on screen is of IST which is converted. So it's a day ahead. 
3. When user submit the job again, the IST converted values are being saved into the database, which is causing the job schedule to change. 

Workaround: Do not resubmit the existing job request. Create a new job request. 

Resolution

Targeted Fix in Release 16.0.3