Schedule Task Monitor Script

Hi Readers,

We have created a new script which was required by our backup team.

They had below requirements:

  • Montor Task Scheduler for failed tasks
  • Send email if the task is failed.
  • Send the error as attachement
  • Send the server name in message subject
  • Only monitor tasks that have name snapshot or backup
  • Updated 02/28/2014 — to cover the tasks that run for hours
  • Updated so that multiple emails for same alert are not received.

So download the attached solution, extract it.

http://gallery.technet.microsoft.com/scriptcenter/Schedule-Task-Monitor-a7c74403

Enter the server names in servers.txt file.

Change the variables accordingly

$hours = “-720”  (-720 ensures if the task is running for some hours than also it is covered, you can increse this value upto -1440)

$matching1 = “snapshot”

$matching2 = “backup”

$email1 = “sukhija@labtest.com”

$from = “ScheduleTask_Monitor@labtest.com”

$smtpserver =”smtp.labtest.com”

Schedule the batch file from task scheduler to run every hour.

PowerShell

################################################################################## 
#       Author:Prakash Yadav 
#       Reviewer: Vikas Sukhija 
#       Date: 11/12/2013 
#       modified:02/28/2013 
#       Description: Schedule Event Failed script. 
################################################################################## 

############# Variables################# 
$date=(get-date).adddays(-1) 
$hours = "-720" 
$matching1 = "snapshot" 
$matching2 = "backup" 
$email1 = "sukhija@labtest.com" 
$from = "ScheduleTask_Monitor@labtest.com" 
$smtpserver ="smtp.labtest.com" 

#################Define Logs############# 
$date1 = get-date -format d 
# replace \ by - 
$time = get-date -format t 

$date1 = $date1.ToString().Replace("/", "-") 

$time = $time.ToString().Replace(":", "-") 
$time = $time.ToString().Replace(" ", "") 

$logs = ".\Logs" + "\" + "Powershell" + $date1 + "_" + $time + "_.txt" 

$emchk1 = ".\Logs" + "\" + "emailcheck" + $date1 + "_.txt" 

Start-Transcript -Path $logs  

if((test-path $emchk1) -like $false) 
{ 
new-item $emchk1 -type file 
} 

##Add servers in text file for which Tasks needs to monitored  
$server_list= Get-Content .\servers.txt 

## Loop thru server List 
foreach ($i in $server_list) 
    { 
        $schedule = new-object -com("Schedule.Service") 
        $schedule.connect("$i") 
        $tasks = $schedule.getfolder("\").gettasks(0) 
        $Failed = $tasks | where-object{($_.LastTaskResult -ne 0) -and ($_.State -eq 3) -and ($_.Name -match $matching1 -or $_.Name -match $matching2)  -and ((get-date).addminutes($hours) -lt $_.LastRunTime)} 

                if ($Failed -eq $Null) 
                    { 
                               write-host "No task failed in last hour for server $i" 
                    } 

                Else 
                    { 
                    foreach ($ta in $Failed) 
                    { 
                    $b = $null > ".\Failed.txt" 
                    $ta >> ".\Failed.txt" 
                    $rcode1 = $ta.Name 
                    $rcode2 = $ta.LastRunTime 
                    write-host "task $rcode1 failed in last hour for server $i" 
########Send Mail with ourPut file as attachments######## 
########Change To/From fields accordingly##########  

$subject ="Task failed at" + "-" +$i + "-"+"Task Name" + "-" + $rcode1  + "-"+"Last Run on" + $rcode2 
$cmp=get-content $emchk1  
$compare = Compare-Object $cmp $subject -IncludeEqual 
$compare1=$compare | where{($_.InputObject -eq $subject) -and ($_.SideIndicator -eq "==") } 
$compare2 = $compare1.InputObject 
write-host "$compare2" -ForegroundColor green 
write-host "$subject" -ForegroundColor blue 

if ($compare2 -ne $subject) 
 { 
 add-content $emchk1 $subject 
$body = $rcode 
$message = new-object Net.Mail.MailMessage 
$smtp = new-object Net.Mail.SmtpClient($smtpserver) 
$message.From = $from 
$message.To.Add($email1) 
$message.body = $body 
$message.Attachments.Add(".\Failed.txt") 
$message.subject = $subject 
$smtp.Send($message) 
$message.dispose() 
 } 
else 
 { 
write-host "email already sent for $subject" 
 } 

                    } 
    } 
} 

Stop-Transcript 
#############################################################################################

Regards

Sukhija Vikas

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s