Cannot insert the value NULL into column ‘owner_sid’, table ‘msdb.dbo.sysjobs’

Hi All

Today we faced below error while creating a new Job @ server XXXXXXXXX . The job was similar to other jobs except Owner of job should be some application user 'domain\user_03'.

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

While trouble shooting i tried to give sa as job owner but face same error. Then we just tried to find SID of user by below query's

select * from sysusers where name = 'DOMAIN\user_03'

sid	name
0x010500000000000515000000AE9EFAED43D316F2BD707BCF318F0400	DOMAIN\user_03

select * from sysusers where name = 'domain\user_03'

NULL

Output is clear : Issue is due to case sensitivity.

Even column name is also case sensitive like SID will not work(Invalid column name 'SID'.) where as sid is working fro sys users table. 

Reason : Collation is Latin1_General_BIN  : this is used to employ case sensitivity due to various reasons