Skip to main content
Planview Customer Success Center

Which SQL Job updates configurable fields and what conditions need to be met?

The job that updates configurable fields is the Validate UDFs job.

The following conditions need to be met :

1. ValidFormula column in the TitleDefinition table needs to be set to 1 (if set to 0 then it will not calculate).
2. Check the LastCaculate column in the same table. The job will not calculate again until LastCalculate date plus the CalculateFrenquency indicated on the column (e.g if frequency is every 1 day then LastCalculate date + 1 day).