Powershell script schedule based on a csv file timing

Question

I have to schedule azure powershell script based on input csv file .

file.csv contents are--
VMName, backupTiming

I need to run my script 2 hours before the timing mentioned in the file.csv(backupTiming).

Could you please suggest on the recommended ways.

@Rich Matheisen @soumi-MSFT @Ian Xue (Shanghai Wicresoft Co., Ltd.) Could you please suggest and help.

Answer 1

Basically you can use (Get-Date '7:30').AddHours(-2)

pls check the below sample code. Haven't tested yet :)

$csvData = @'  
VMName, backupTiming-EST  
machine1-poc,07:30  
'@ | ConvertFrom-Csv  
  
$csvData | ForEach-Object {  
    $ScheduledAt = (Get-Date $_.'backupTiming-EST').AddHours(-2)  
    $Trigger = New-ScheduledTaskTrigger -Once -At $ScheduledAt  
      
    $action = New-ScheduledTaskAction -Execute "Your script" -Argument 'Your args'  
    $principal = New-ScheduledTaskPrincipal -UserId 'DOMAIN\user' -RunLevel Highest  
    $settings = New-ScheduledTaskSettingsSet  
    $task = New-ScheduledTask -Action $action -Principal $principal -Trigger $trigger -Settings $settings  
    Register-ScheduledTask -TaskName ($_.VMName + '_' + $ScheduledAt.ToString('s') ) -InputObject $task  
}