SQL Server error

Cannot insert the value NULL into column ‘owner_sid’, table ‘msdb.dbo.sysjobs’; column does not allow nulls. INSERT fails.

If you get the above message, make sure you set the login correctly in the script you are attempting to run: For example, on my script that causes the error above,
changing
@owner_login_name=N’sa’,
to
@owner_login_name=N’stevesadminaccount’,
Obviously logging in as sa would have solved the problem, but thats not a recommended safe practise.

Leave a Reply