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.
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.
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.
sql jobs shows error
Posted - 07/14/2009 : 03:30:29
