"The specified '@notify_email_operator_name' is invalid" error

Question

I have a scripted SQL Server Agent job I'm trying to transfer over to my local database from a server, but I receive this error message:

Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line 243 The specified '@notify_email_operator_name' is invalid (valid values are returned by sp_help_operator).

Double clicking the error message won't even take me to the line that it fails on. Has anybody else gotten this before?

Answer 1

Use Ctrl+F to find where @notify_email_operator_name appears. It probably is set to an email profile that you haven't set up on your local machine.

For SQL Server 2005 and above, then you can set up database mail using an SMTP server.

In your case, you might just be doing some testing on your machine, and you might not care about the email notifications so you can safely set @notify_email_operator_name = NULL and then re-run the script.