I recently installed ms sql server 2008 64 bit on some machines. I then reached a point where I have to create jobs and automate some administrative tasks. We have previously written T-SQL scripts which I now want to use to automate tasks.
I did the following:
I created a new job, gave job name, from the list I chose T-SQL script, created a new step, opened the T-SQL script from file location on the local machine. That was done.
I am a member of sys admin. When I run the job I get the following error message:
can not insert the value NULL into column 'owner_sid', 'table msdb.dbo.sysjobs' column does not allow NULLS. Insert fails.
I was really wondering if anyone can give a hint on how to solve this problem.
Many thanks indeed in advance.