Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Server Agent jobs Expand / Collapse
Posted Monday, May 4, 2009 6:35 AM


Group: General Forum Members
Last Login: Tuesday, December 15, 2015 4:01 AM
Points: 154, Visits: 467
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.


Post #709342
Posted Monday, May 4, 2009 10:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 25, 2011 7:56 AM
Points: 7, Visits: 2,810
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.
Post #709517
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse