November 21, 2017 at 7:52 am
We have an audit setup to capture if a job has been added deleted or updated and it works perfect. I have sent a test email to myself and that works
we have created three alerts for the above but they will not email not sure why
USE [msdb]
GO
/****** Object: Alert [AddJob] Script Date: 11/21/2017 9:45:55 AM ******/
EXEC msdb.dbo.sp_add_alert @name=N'AddJob',
@message_id=0,
@severity=1,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=
@notification_message=N'
@event_description_keyword=N'
@category_name=N'[
@job_id=N'00000000-0000-0000-
GO
November 21, 2017 at 7:54 am
myukas - Tuesday, November 21, 2017 7:52 AMWe have an audit setup to capture if a job has been added deleted or updated and it works perfect. I have sent a test email to myself and that works
we have created three alerts for the above but they will not email not sure why
USE [msdb]
GO
/****** Object: Alert [AddJob] Script Date: 11/21/2017 9:45:55 AM ******/
EXEC msdb.dbo.sp_add_alert @name=N'AddJob',
@message_id=0,
@severity=1,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=1,
@notification_message=N'Database Job has been changed',
@event_description_keyword=N'EXEC msdb.dbo.sp_add_job',
@category_name=N'[Uncategorized]',
@job_id=N'00000000-0000-0000-0000-000000000000'
GO
Have you enabled the mail profile for the SQL agent to use along with operators and restarted the agent to pick up the configuration?
November 21, 2017 at 8:18 am
i do but did not restart the agent
November 21, 2017 at 10:05 am
that worked thank you
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply