A couple of things - first, using '%harch%' requires a full table/index scan because of the leading wildcard.  Second, you need to review the code in the view to see...

Was the original owner of the agent job also a sysadmin in SQL Server?

I am thinking something has changed for the service account running SQL Server and/or SQL Server Agent. ...

Now that you got a path forward...make sure you setup daily backups and frequent transaction log backups - and verify those backups (as often as you can).

And...you really need to...

Does that view access a table across a linked server?  You say the script works fine if you execute it manually - but does that include the send mail portion? ...

I don't think that is going to be possible - and I was fairly certain you would not be able to identify anything by the varbinary column.  You might be...

That is unfortunate - I would recover from the full backup (to a new database) and apply all transaction log backups you do have available and then compare the data...

Will try the page check option and see if that gets me any more info.

Regarding restoring from a previous backup - to clarify, I do have a working backup...

The page output doesn't appear to be the data page - you should review the article at https://www.mssqltips.com/sqlservertip/1578/using-dbcc-page-to-examine-sql-server-table-and-index-data/

Or this one: https://www.sqlskills.com/blogs/paul/inside-the-storage-engine-using-dbcc-page-and-dbcc-ind-to-find-out-if-page-splits-ever-roll-back/

What you need is the page with the data associated...

I am not sending you anything - if you are...

If you use the Import/Export wizard to create a package - you have the option of saving that package and can edit/change the package using SSDT (Visual Studio).

However - if...

Based on the errors - I am not sure you have the option to repair.  As for identifying the data - you can try inspecting every page using DPCC PAGE...

Yes, sorry, as I stated in passing earlier, what I meant was that you "can't" in practice even if you can in theory because it takes so long to...

Duplicates - requiring DISTINCT...

Duplicates - requiring DISTINCT or GROUP...

However, if you "don't break the log chain", and something happens after the rebuilds, you WILL lose all data mods after the rebuilds, since you can't forward-recover using the...