If(Get-Content -Path $dir$LatestRefreshLog | %{$_ -match "RESTORE DATABASE successfully processed"})
  {
   #Write-Host "The latest restore log file is $LatestRefreshLog"
   $msg.Subject = "SQLServer QA Refresh Status"
   $msg.Body = "QA DB is refreshed successfully."
   $smtp.Send($msg)
  }
  else
  {
   #Write-Host "The latest restore log file is $LatestRefreshLog"
   $msg.Subject = "SQLServer QA Refresh Status"
   $msg.Body = "QA DB refresh is having issues.Restore failed."
   $smtp.Send($msg)
 } }