we have 3 environment for ADF DEV QA & prod ,we Need to update ADF trigger time in QA & Prod after each deployment as after deployment DEV trigger time have beed updated every time.
i wrote below code in power shell scrit but i could not able to set weekdays From Monday-Saturday. geting error ##[error]Exception setting “WeekDays”: “Cannot convert the “System.Object[]” value of type “System.Object[]” to type “System.Collections.Generic.IList1[System.Nullable
1[Microsoft.Azure.Management.DataFactory.Models.DaysOfWeek]]”.”
i tried with 2 ways to setup weekdays
$trigger.Properties.Recurrence.Schedule = New-Object Microsoft.Azure.Management.DataFactory.Models.RecurrenceSchedule
$trigger.Properties.Recurrence.Schedule.WeekDays= @("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday")
And 2nd in the below code sample
$adf_name = $env:Adf_Name
$resourcegroup_name = $env:ResourceGroup_Name
$blobContainerName = $env:blobContainerName
$StorageAccountName= $env:StorageAccountName
Write-Host "adf_name : $adf_name "
Write-Host "resourcegroup_name : $resourcegroup_name "
Write-Host "blobContainerName : $blobContainerName "
Write-Host "StorageAccountName: $StorageAccountName"
$triggerName = "Dwh_Business_Days_MTD_Data_Load"
Write-Host "triggerName: $triggerName"
#"Dwh_Business_Days_MTD_Data_Load" "Dwh_Salesforce_Belden_Data_Load"
$timeZone = "Eastern Standard Time" # Set to Eastern Standard Time (EST)
$startTime = [datetime]::ParseExact("04:40:00", "HH:mm:ss", $null) # Set trigger time
# Step 3: Get the trigger
$trigger = Get-AzDataFactoryV2Trigger -ResourceGroupName $resourcegroup_name -DataFactoryName $adf_name -Name $triggerName
Write-Host ($trigger.Properties | Format-List -Property * | Out-String)
#Write-Host ($trigger | Format-Table | Out-String)
# Step 4: Define the recurrence schedule
$trigger.Properties.Recurrence = New-Object Microsoft.Azure.Management.DataFactory.Models.ScheduleTriggerRecurrence
$trigger.Properties.Recurrence.Frequency = "Week"
$trigger.Properties.Recurrence.Interval = 1
$trigger.Properties.Recurrence.StartTime = $startTime
$trigger.Properties.Recurrence.TimeZone = $timeZone
$trigger.Properties.Recurrence.Schedule = New-Object Microsoft.Azure.Management.DataFactory.Models.RecurrenceSchedule
**$trigger.Properties.Recurrence.Schedule.WeekDays= [Microsoft.Azure.Management.DataFactory.Models.DaysOfWeek]::Monday, `
[Microsoft.Azure.Management.DataFactory.Models.DaysOfWeek]::Tuesday, `
[Microsoft.Azure.Management.DataFactory.Models.DaysOfWeek]::Wednesday, `
[Microsoft.Azure.Management.DataFactory.Models.DaysOfWeek]::Thursday, `
[Microsoft.Azure.Management.DataFactory.Models.DaysOfWeek]::Friday, `
[Microsoft.Azure.Management.DataFactory.Models.DaysOfWeek]::Saturday**
$trigger.Properties.Recurrence.Schedule.Hours = @(4) # 4 AM EST
$trigger.Properties.Recurrence.Schedule.Minutes = @(40) # 40 minutes
# Step 5: Update the trigger in ADF
Set-AzDataFactoryV2Trigger -ResourceGroupName $resourcegroup_name -DataFactoryName $adf_name -Name $triggerName -Definition $trigger.Properties
please help me out.