Search code examples
sql-serverssisjob-schedulingsql-server-2008sql-agent-job

Create failed for Job 'SSIS Package Exec'


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.

enter image description here

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!


Solution

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