1
Vote

Install error AgentJobs log

description

I just tried to run the InstallDMVStatsDBProcs.cmd and got an error in CreateDMVstatsSQLAgentJobs.log.
Has anyone else experienced this?
 
Changed database context to 'msdb'.
Msg 515, Level 16, State 2, Server MYSERVER, 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.
 
Brian

comments

ltevere wrote Jul 17, 2007 at 7:33 PM

Brian - I ran into the same problem. I was able to resolve it by modifying the CreateDMVstatsSQLAgentJobs.sql script. I changed the @owner_login_name parameter of the sp_add_job procedure call (all 5 instances) to the service account name that I use to run the the SQLAgent.

HTHlt

brian_sutherland wrote Jul 19, 2007 at 2:11 AM

Thanks, worked a treat.

srini_TDXGROUP wrote Oct 2, 2009 at 1:55 PM

Hi ,

check while gettign script from which server and
ex:@owner_login_name=N'Wipro'

on whihc server you running.


@owner_login_name=N'Wipro1'

then it iwll work no doubt. on that.

wrote Feb 14, 2013 at 1:29 AM