email recipients in agent notifications

  • as you can see at https://www.sqlservercentral.com/forums/topic/notifications-in-sql-agent we have a couple of folks being emailed hopefully upon completion of tha job.

    how can i add my name/email to that list?  do i have to script the job 's definition and rerun the script?

  • i do see this in the definition script but have to wonder how sql associates these names with emails.  Am i going to be typing "and my name"?   How will sql know who i am and what my email is?

    EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N'DW Load',

    @enabled=1,

    @notify_level_eventlog=0,

    @notify_level_email=3,

    @notify_level_netsend=0,

    @notify_level_page=0,

    @delete_level=0,

    @description=N'No description available.',

    @category_name=N'[Uncategorized (Local)]',

    @owner_login_name=N'sa',

    @notify_email_operator_name=N'John Doe and Jane Doe', @job_id = @jobId OUTPUT

  • for some reason a duplicate reply was posted here after i got an error on the first reply.  sorry.

    • This reply was modified 1 week, 5 days ago by  stan. Reason: duplicate reply after forum threw an error on first reply
  • Check out the SQL Server Agent/Operators node in SSMS and it should help answer your question.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply