"The specified '@notify_email_operator_name' is invalid" error

sql-server sql-server-2008 sql-server-agent
broke picture broke · Nov 2, 2011 · Viewed 28.1k times · Source

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

Davos picture Davos · Dec 9, 2011

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.

Related questions

How do I execute a stored procedure in a SQL Agent job?

I am using SQL Server 2008 and I need to run a SQL Job from SQL Server Agent. I am new to SQL Server Job and I want to execute a stored procedure regularly from a SQL Server Job. But I …

Read More
SQL Server Agent Job Notify multiple operators on failure

I have a Job setup in SQL Server 2008 which sends a notification email to one operator when the job fails. Question: Is it possible to setup a notification email being sent to multiple operators for that specific job? I believe …

Read More
How to set up SQL server Agent? not showing in Sql Server Management

I am trying to set up the SQL Server Agent on our test server running with windows Small Business Server 2011 Standard and SQL Server 2008 R2 RTM. The Sql Server Agent node is not displayed in Sql management studio. Here is …

Read More