Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raveekumarg
Starting Member
36 Posts |
 Posted - 2009-07-14 : 03:30:29
|
| hi allMy 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 grkravi |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-14 : 03:54:35
|
| Did you check the report file of the Job-------------------------R.. |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-14 : 04:40:44
|
| 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. |
|
|
|
raveekumarg
Starting Member
36 Posts |
Posted - 2009-07-14 : 05:50:49
|
| thanks....yes it connected to some other network ( two different servers), how to give access to the sql agent accountravi |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-14 : 05:59:03
|
| Via windows I would guess. Ask your System Admin to do it. |
|
|
|
raveekumarg
Starting Member
36 Posts |
Posted - 2009-07-14 : 06:18:01
|
| experts pl update on the same...ravi |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-14 : 06:31:52
|
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.Orwww.justfuckinggoogleit.com |
|
|
|
raveekumarg
Starting Member
36 Posts |
Posted - 2009-07-15 : 01:52:20
|
| experts...i am strucked...help to proceedravi |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-07-15 : 14:53:11
|
| 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. |
|
|
|
|
|
|
sql jobs shows error