net send multiple operators when job completes

• ZenDada

  SSCarpal Tunnel

  Points: 4637

  More actions

  July 21, 2004 at 2:43 pm

  #108511

  I net send the manager when MyJob completes.  I do this through the job properties dialog box.  It only seems to allow one operator.  I would also like to net send myself.  I need to know if the job status when it completes so that I can fix it if it fails.

  Any ideas?

  [font="Courier New"]ZenDada[/font]

• hoo-t

  SSChampion

  Points: 12713

  More actions

  July 23, 2004 at 3:14 pm

  #515969

  Just add a step to your job with...

  EXEC master.dbo.xp_cmdshell 'NET SEND MyUserID ''This is a test'''

  Steve