May 4, 2009 at 6:35 am
Hi all,
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.
Regards
Niyala
May 4, 2009 at 10:54 am
I've run into this before (but with 2005) and had to manually edit the job script. In a nutshell the line breaks don't occur as you'd expect so I went through and added the line breaks as needed.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply