ok, changed that line back to

iWaitInMinutes = 1

iAlertFreq = 1

sAnalysisInstance = "server\instance"

sAnalysisDB = "dbName"

and the other line is now....

sConnString = "Server=" & sAnalysisInstance & ";Database=" & sAnalysisDB & ";UID=SCOMADMIN;PWD=mysupercomplexpassword"

But I have yet to receive a single notification.

I made sure I created a new subscription based on Sql Servers, too. Anything I can check on the SQL side to see if it is even collecting anything yet?