Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Agent jobs Expand / Collapse
Author
Message
Posted Monday, May 04, 2009 6:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:46 AM
Points: 154, Visits: 427
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
Post #709342
Posted Monday, May 04, 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