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?
July 9, 2024 at 11:12 am
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
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