January 24, 2007 at 6:13 am
I have a job running on a server, and i am trying to copy it onto another server. i scripted the job and then ran the script on the new server but i get this error when i try to add the job:
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).
Does anyone know what this error means and how to resolve it?
January 24, 2007 at 6:20 am
Does the job email a named operator on success/failure?
If so you might need to script the operator (or add the operator to the server with the same name manually) - you can use SSMS or call
EXEC sp_add_operator @name=N'operatorName', @email_address='james@someAddress.com'
(see http://msdn2.microsoft.com/en-us/library/ms186747.aspx for other parameters) or you can just remove the @notify_email_operator parameter from the call to sp_add_job in the script however the job will nolonger email on success/failure.
- James
--
James Moore
Red Gate Software Ltd
January 24, 2007 at 7:51 am
yep, that sorted it. i ran "sp_help_operator" on on the source database, found the operators that were there, and added them to the new database using the data provided by you :
EXEC sp_add_operator @name=N'operatorName', @email_address='james@someAddress.com'
Thanks for all the help!
August 16, 2011 at 4:57 am
This helped me as well.
Thanks!
September 15, 2015 at 5:51 pm
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply