So you want to loop around 5 servers, pull the backup information, then store that data in ABC server in database DB?

Channelling my inner Brent...............

What is the problem you are trying to solve by changing the whole collation?

Oh boy.

Seriously the logic will always give you rows.

If you check @@ROWCOUNT after setting @BODY you will have a rowcount of 1

If you check COUNT(*) from #temp table you will...

Sorry, I thought I read script it to copy somewhere else.

Yeah if you to the Get-DbaAgentJob then you can pipe that to Export-DbaScript

Get-DbaAgentJob -SqlInstance MySQLServer -Job MyBackupJob|...

Are you able to use DBATools at all?

They have a ready made function for scripting/copying jobs

https://docs.dbatools.io/Copy-DbaAgentJob

You need to put a count or if exists condition around the mail part.  So that if there’s no rows which match the select used to generate the html it...

In an AG you don't make the storage shared storage, everything is managed at the replica level.

The only reason for the WSFC is for the role failover capabilities.

Any compute resources,...

Go speak with your mail admins and work out where it is failing.

Your error is you’re not authenticating properly or you’re not using a secure connection.

Go work with your mail...

As you posted in the 2019 forum area also this shouldn't apply to you, but incase you're on SQL2016 or below, you may need to add the registry keys at...

Speak with your O365 admins then to see why it is saying you are unauthenticated.

Make sure you have SSL enabled.

Make sure you have TLS enabled.

You need to authenticate with O365.

Use basic authentication and give it the email address and password needed to login to that mailbox you wish to send mail as.

Logins here will be something you would want to do manually as you can't just simply create

CREATE LOGIN [DOMAIN\Group] FROM WINDOWS

etc, if they are in Entra as...

Logins here will be something you would want to do manually as you can't just simply create

CREATE LOGIN [DOMAIN\Group] FROM WINDOWS

etc, if they are in Entra as...

MSFT have a doc with the steps on that topic.

https://learn.microsoft.com/en-us/sql/database-engine/log-shipping/fail-over-to-a-log-shipping-secondary-sql-server?view=sql-server-ver16#see-also

Let us know is you need any further clarification.

Doh, thanks Frederico, more coffee certainly needed this morning