Schedule job not creating disable task from analytics in proper time

[ARNAB86]

Hi Team,

We have written the below query based on that the disable account task gets created

a.name,
a.accountkey AS acctKey,
a.endpointkey,
'disableAccount' AS Default_Action_For_Analytics
FROM
accounts a
JOIN
user_accounts ua ON a.accountkey = ua.accountkey
JOIN
users u ON ua.userkey = u.userkey
WHERE
AND a.endpointkey = 3
AND u.customproperty14 = DATE_FORMAT(NOW(), '%d-%m-%Y')
AND a.status IN (1, 'Manually Provisioned')

Lets clear more if i set the customproperty14 value as 18-07-2024 , so when the job run first at 12:00 am it should create the disable task.But i observed it is creating the disable task at 05:30 am IST which seems to be issue with UTC time.

Could you please help how to resolve it in the above query so it should pick the value right 12:00 am itself

Thanks

Arnab Pal

[Raghu]

@ARNAB86  can you check 12AM IST compare UTC time zone and schedule it.

[rushikeshvartak]

Always best practice schedule job either +5 minute if needed at start of day.