Complete guess! Liking the R stuff, thanks Steve.

Thanks Steve, a good to start the week!

Curious to know why if there are no database files on the OS partition i.e. C: drive, you say in your first post you are shrinking transaction logs? If they...

It is not clear as to your actual setup to know what to suggest: In terms of the SQL server logs and SQL Agent logs, that are titled "Archive #1"...

An off the peg thought, has the agent service account been changed at all?

Only one, check sent items and if sent get mail admin to check logs. You may also want to try the same thing in ssms.

Permissions? Can you browse to the folder or share? If not does it exists? Personally I replace maintenance plans with SQL agent jobs.

Incidentally you should obfuscate your email address, domain and mail profile.

Tried to recreate error, the code runs fine for me and I get the mailed report. I can only suggest it is the data that is capturing a null or...

Other post here: https://www.sqlservercentral.com/Forums/1916761/FOR-XML-could-not-serialize-the-data-for-node-because-it-contains-a-character-0x0000-which-is-not-al

Good question thanks Steve, also spotted the typo.