Powershell script for MS sql server RRS feed

  • Question

  • team,

    i need a PowerShell script each below, 

    1. powershell to check,  sql job named "abc_input" .  if it's available then leave it, else  create that job.
    2. powershell to check. sql job named "abc_input" . if it's contain last step named "job3" , then remove last step.
    3. powershell need to create DB mail configuration  ( by passing input arguments ).
    4. powershell need to create sql alerts  ( by passing input arguments ).
    Thursday, November 19, 2020 12:06 PM