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

ERROR:

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

EXPLANATION:

Because a server will be physically changed, we’ve created a SQL Server Instance on the new server. You know, we need to transfer logins, Linked Servers, SSIS packages, Job. We received this error message when transferring a Job during these operations.

SOLUTION:

When running sp_add_job system SP, make sure that the login that is specified as the value of the @owner_login_name parameter exists on the destination server. If not, either create or replace with another appropriate login.