Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error with _dbaMain..spxCreateIDXMaintenanceJob Expand / Collapse
Author
Message
Posted Tuesday, September 25, 2012 9:47 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:03 AM
Points: 55, Visits: 372
I'm at the tail end of the "CH1_Listing_1_Automated_Configuration_Script.sql" script. I'm on the
--Create Index Maintenance Job
USE DBA_Rep
go

EXEC _dbaMain..spxCreateIDXMaintenanceJob
'Admin Profile'
, 'sqlsupport'
, 'Sunday'
, 0

section. Whenever I execute it I get:
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).

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 137
Cannot 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!



======================================================
John
SQL Server 200x Newb and proud of it!
======================================================
Post #1364147
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse