Styjun

I want create the script on PS, with such algorithm

1. 
   

   there is a CSV file

   
   
   

   
   "C:UsersadminDocumentsf.csv"
   

   
   
   

   Its format is now

   
   
   

   
   "", "promoaction", "promoeffect1", "returneff", "promo_return", "dataload"
   "1", 18557,18568,0,18557,2019-03-23 ​​17:11:28
   

   
   
   

   every Monday morning, at 11 o'clock, the csv file is updated with a new row,
   for example, the 25th of March may be so.

   
   
   

   
   "", "promoaction", "promoeffect1", "returneff", "promo_return", "dataload"
   “2”, 18558,18568,0,18558,2019-03-25 11:00:00
   

   
   


2. 
   

   So, how to do, that if the values of columns promoaction and promo_return (do not touch other columns, their value is not important)
   less than their values in previous date (dataload column)?

   
   
   

   For example

   
   
   

   
   "", "promoaction", "promoeffect1", "returneff", "promo_return", "dataload"
   "3", 1000,18568,0,1000,2019-03-25 11:00:00 (1000 <18558)
   

   
   
   

   and also, if values in promoaction and promo_return columns ​​became not equal, for example, in promoaction = 1000, and in promo_return = 2000.

   
   

All tasks which I indicated

task1,task2

for Tuesday (there are many tasks, it run on taskschd.msc once a week on Tuesday) should not start, but simply postpone execution to the next Tuesday.

Well, if the promoaction and promo_return values are greater than in the previous date, and the values are promoaction = promo_return then everything is fine, do not turn off anything.

This ps should run every monday at 12 noon. In case when, tasks have been disabled, create a .txt file with a warning on the desktop ("tasks in the scheduler are disabled")

How to do it, now I done that

$sSourceFile = 'C:my projects254f.csv'

$aCSV = Import-Csv -Path $sSourceFile -WarningAction SilentlyContinue

if ($aCSV.Count -ge 2) 
 $lUpperBound = $aCSV.GetUpperBound(0)

 $lCurrPromoAction = $aCSV[$lUpperBound].promoaction
 $lCurrPromoReturn = $aCSV[$lUpperBound].promo_return
 $lPrevPromoAction = $aCSV[$lUpperBound - 1].promoaction
 $lPrevPromoReturn = $aCSV[$lUpperBound - 1].promo_return

 Write-Host $lCurrPromoAction, $lCurrPromoReturn, $lPrevPromoAction, $lPrevPromoReturn
 else 
 Write-Host "Need at least two strings in csv file [$sSourceFile]."

but this script just compares the rows different, but it doesn't disable tasks from taskschd.msc and doesn't postpone execution to the next Tuesday.

How to do, that if there is difference between rows, then disable indicated task.