Yep, I was missing an END. That fixed the issue. Thanks!

Not trying to be lazy but one of the server has 128 jobs and some of the jobs have multiple steps, some have SSIS packages. Am I to go through...

Tried string, Unicode string but nothing. Still see NULL value

It's working now.

Some of them.

Do you take log backups? The reason why I am asking is because if you do then you just have to find out the pattern. I mean look at the log backups...

Its fixed.
We don't use our regular account to log onto instances. Instead we use admusername. So what I did was I logged into my laptop using adm account, changed...

I am using the listener name instead of the server name and it is working just fine. Tested the job by manually failing over so no issues so far.

This is the script I am using which I found online, made some changes and it's working just fine.

DECLARE @name VARCHAR(256) -- database name

Emails are being sent fine. I checked the DB mail log and I don't see any issue.

still no email after I failed it over to the secondary. I did receive an email when I sent myself a test email so its not the SMTP server. There is something...