Update SQL job step

• SQL_Surfer

  SSCrazy Eights

  Points: 8316

  More actions

  November 5, 2013 at 9:31 am

  #278906

  I need to add my email address on the failure steps on SQL agent....There are hundred of jobs setup and I need to add my emailid on all. Is there easy way to do this instead of going manually adding one by one?

• Sean Pearce

  SSCoach

  Points: 15999

  More actions

  November 6, 2013 at 3:54 am

  #1664375

  Do you want to update a notification or a step command?

  Notification

  sp_update_job [ @job_id =] job_id | [@job_name =] 'job_name'

  [, [@notify_level_email =] email_level ]

  [, [@notify_email_operator_name =] 'email_name' ]

  Step Command

  sp_update_jobstep

  { [@job_id =] job_id

  | [@job_name =] 'job_name' } ,

  [@step_id =] step_id

  [ , [@step_name =] 'step_name' ]

  [ , [@command =] 'command' ]

  

  The SQL Guy @ blogspot[/url]

  @SeanPearceSQL

  About Me[/url]