select
name,
'/*'
+ name
+'*/
'
+'EXEC msdb.dbo.sp_update_job @job_id=N'
+ '''' +
cast(job_id as varchar(255))
+ '''' +
',
@notify_level_email=2,
@notify_level_netsend=2,
@notify_level_page=2,
@notify_email_operator_name=N''EC-DBAs'''
from msdb.dbo.sysjobs
where enabled = 1
and notify_level_email = 0
--and name like 'basic%'
order by name
