DECLARE @SQL VARCHAR(MAX)
SELECT @SQL = Util.dbo.StringConcat('EXEC msdb.dbo.sp_update_job @job_id=N''' + CAST(job_id AS VARCHAR(200)) + ''',
@notify_level_netsend=2,
@notify_level_page=2,
@notify_email_operator_name=N''''
', '
')
FROM msdb.dbo.sysjobs (NOLOCK)
WHERE name LIKE '%cleanup%log%'
AND ISNULL(notify_email_operator_id, 0) > 0
EXEC Util.dbo.PrintLargeText
@SQL
IF @SQL <> ''
EXEC(@SQL)