SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sql jobs shows error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

raveekumarg
Starting Member

India
36 Posts

Posted - 07/14/2009 :  03:30:29  Show Profile  Reply with Quote
hi all

My scheduled sql jobs are showing the below error
"Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."
but on the same time the package of that job was working when manually run.

thanks
grk



ravi

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 07/14/2009 :  03:54:35  Show Profile  Send rajdaksha a Yahoo! Message  Reply with Quote
Did you check the report file of the Job

-------------------------
R..
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3603 Posts

Posted - 07/14/2009 :  04:40:44  Show Profile  Reply with Quote
If it runs fine manually, it is a rights issue, does your package connect to network drives? The SQL Agent account needs rights to any drives that are required for the package to work.

The reason it works manually inthis situation is that it is running under the users account and has access to anywhere you have access toi, but when it is scheduled, it runs under the SQL Agent account instead.
Go to Top of Page

raveekumarg
Starting Member

India
36 Posts

Posted - 07/14/2009 :  05:50:49  Show Profile  Reply with Quote
thanks....yes it connected to some other network ( two different servers), how to give access to the sql agent account

ravi
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3603 Posts

Posted - 07/14/2009 :  05:59:03  Show Profile  Reply with Quote
Via windows I would guess. Ask your System Admin to do it.
Go to Top of Page

raveekumarg
Starting Member

India
36 Posts

Posted - 07/14/2009 :  06:18:01  Show Profile  Reply with Quote
experts pl update on the same...

ravi
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3603 Posts

Posted - 07/14/2009 :  06:31:52  Show Profile  Reply with Quote
quote:
Originally posted by raveekumarg

experts pl update on the same...

ravi


X-Spurts only?!?

Please take into account what I said. If you don't know how to grant access to a windows user, ask your SysAdmin.

Or

www.justfuckinggoogleit.com
Go to Top of Page

raveekumarg
Starting Member

India
36 Posts

Posted - 07/15/2009 :  01:52:20  Show Profile  Reply with Quote
experts...i am strucked...help to proceed

ravi
Go to Top of Page

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 07/15/2009 :  14:53:11  Show Profile  Click to see tripodal's MSN Messenger address  Reply with Quote
Right click the file inquestion.
Left click properties.
At the top there will be several tabs.
Left click security.
Left click Add (or Advanced)
Type in the name of the user account sql agent uses.
left click add.
Left click on the individual permissions you cant that user to have to that file.

Repeat for each file.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000