Execute ADF at 12:00 AM UTC using wait activity

Sarvesh Pandey 71

HI all,
I want to trigger my ADF pipeline at 12:00 AM UTC by using a wait activity (Note- Pipeline get trigger using blob event)
I am using below script but on while monitoring it holds for only 1 sec, Can someone help me where it is getting wrong
@if(
equals(
formatDateTime(convertTimeZone(utcNow(),'UTC','India Standard Time'),'dd'),
formatDateTime(utcNow(),'dd')
),
1,
sub(
mul(24,3600),
add(
int(if(equals(
formatDateTime(convertTimeZone(utcNow(),'UTC','India Standard Time'),'dd'),
formatDateTime(utcNow(),'dd')
),'59',formatDateTime(utcNow(),'ss'))),
add(
mul(int(if(equals(
formatDateTime(convertTimeZone(utcNow(),'UTC','India Standard Time'),'dd'),
formatDateTime(utcNow(),'dd')
),'59',formatDateTime(utcNow(),'mm'))),60),
mul(int(if(equals(
formatDateTime(convertTimeZone(utcNow(),'UTC','India Standard Time'),'dd'),
formatDateTime(utcNow(),'dd')
),'23',formatDateTime(utcNow(),'HH'))),3600)
)
)
)
)

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2022-05-13T16:29:57.777+00:00

Hello @Sarvesh Pandey ,

Thanks for the question and using MS Q&A platform.

Could you please elaborate a bit on your requirement? I want to trigger my ADF pipeline at 12:00 AM UTC by using a wait activity (Note- Pipeline get trigger using blob event) - This statement is a but confusing. Do you want to schedule the pipeline using a Schedule trigger or you would want to trigger the pipeline as soon as the blob is available in the source location? Please elaborate a bit on the usage of wait activity here so that we can better assist you.

Thank you
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2022-05-17T19:28:05.05+00:00

Hello @Sarvesh Pandey ,

To better assist on this query, could you please clarify a bit as per my previous comment?

Thank you