There were a bunch of jobs that I needed to enable email notifications in case of a failure. I came up with this quick and dirty way:
DECLARE @job_id1 nvarchar(200) DECLARE updateOperator CURSOR FOR select job_id from msdb..sysjobs WHERE enabled = 1 OPEN updateOperator FETCH NEXT FROM updateOperator INTO @job_id1 WHILE @@FETCH_STATUS = 0 BEGIN EXEC msdb.dbo.sp_update_job @job_id= @job_id1, @notify_level_email=2, @notify_level_netsend=2, @notify_level_page=2, @notify_email_operator_name=N'Master-DBA' FETCH NEXT FROM updateOperator INTO @job_id1 END CLOSE updateOperator DEALLOCATE updateOperator