• Yes. The easiest way is to go set something up like you want it in SSMS, then script out the alert.

    And in terms of further automation, your best bet beyond what I wrote would be to investigate scripting the whole thing in powershell.