Matthew Darwin (3/20/2014)
The alert is the stock one created when configuring log shipping as follows:-
EXEC msdb.dbo.sp_add_alert @name=N'Log shipping Primary Server Alert.',
@message_id=14420,
@severity=0,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=1,
@category_name=N'[Uncategorized]',
@job_id=N'00000000-0000-0000-0000-000000000000'
The job successfully raises the error, and this is logged in the SQL Server log.
If I manually raise the error, then it still doesn't fire the trigger.
Check if the Operator & Notifications are enabled.
Also check in the SQL Server Agent properties, if you have enabled the Mail Profile.
--
SQLBuddy