Create failed for Job 'SSIS Package Exec'

Question

I created an SSIS package entitled "DimEntity.dtsx"

I followed the instructions from this link to run this SSIS package using a scheduled Job.

http://blog.sqlauthority.com/2011/05/23/sql-server-running-ssis-package-in-scheduled-job/

After following the process of running-ssis-package-in-scheduled-job, I got this error after clicking OK from the image below.

Create failed for Job 'SSIS Package Exec'. (Microsoft.SqlServer.Smo)

---

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

---

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. (Microsoft SQL Server, Error: 515)

---

Could someone help me resolve this?

Thank you!

Answer 1

Select General on the left tab and enter a value for owner.

Answer 2

Try setting the owner manually:

update msdb.dbo.sysjobs_view 
set owner_sid=suser_sid('<username or groupname here>',0) 
where name = 'jobname'