InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 00:15:00 GMT20http://www.sqlservercentral.com/Forums/Topic1364147-1015-1.aspxI'm at the tail end of the "CH1_Listing_1_Automated_Configuration_Script.sql" script. I'm on the --Create Index Maintenance JobUSE DBA_RepgoEXEC _dbaMain..spxCreateIDXMaintenanceJob 'Admin Profile' , 'sqlsupport' , 'Sunday' , 0section. Whenever I execute it I get:Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line 243The specified '@notify_email_operator_name' is invalid (valid values are returned by sp_help_operator).If I throw email addresses in either of the first 2 variables, I get:Msg 515, Level 16, State 2, Procedure sp_add_job, Line 137Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.The statement has been terminated.I've tried several different variables on this stored proc with no luck. So close but yet so far.Hopefully this discussion doesn't sit too long.Thank you!Tue, 25 Sep 2012 09:47:00 GMTJohn Waclawski