--To update all jobs that do not have email notification enabled I run this:

DECLARE @jobid AS NVARCHAR(MAX)

DECLARE jobstep_cursor CURSOR FOR

SELECT job_id

FROM msdb.dbo.sysjobs

WHERE enabled = 1 AND notify_level_email = 0

OPEN...