March 26, 2010 at 12:40 pm
Hi..
I have created the maintenance plan for the event check database integrity with windows authentication mode.but while starting the job its giving the error message in sql agent job history.
"Executed as user: DUDE\SYSTEM. The package could not be loaded. The step failed.Message "Executed as user: DUDE\SYSTEM. The package could not be loaded. The step failed." "
But other job(backup) is running running successfully with windows authentication mode.this windows user is member of the local system administrator account.
No error has been logged in the sql server agent error log and sql server error log as well.
Can anyone tell me the reason for this job failure or give me any suggestion to run the agent successfully?.
March 26, 2010 at 2:02 pm
Have you enabled logging (under the advanced tab of the job step properties)? If not, enbable it, then check the log file for more detailed info.
Also, copy the job step T-SQL command. Run it manually. Does it run? What are the errors?
Just for the hell of it, can you manually run a DBCC Check DB?
It sounds like you have a package to run the DBCC Check DB, right? Can you manually run the package?
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
March 26, 2010 at 3:11 pm
Is it using same windows account as back up job maintenance task?
March 27, 2010 at 5:31 am
GregoryF (3/26/2010)
Have you enabled logging (under the advanced tab of the job step properties)? If not, enbable it, then check the log file for more detailed info.Also, copy the job step T-SQL command. Run it manually. Does it run? What are the errors?
Just for the hell of it, can you manually run a DBCC Check DB?
It sounds like you have a package to run the DBCC Check DB, right? Can you manually run the package?
Have you enabled logging (under the advanced tab of the job step properties)? If not, enbable it, then check the log file for more detailed info.
Ans: Yes Enabled.but there is no detailed error message.
Also, copy the job step T-SQL command. Run it manually. Does it run? What are the errors?
Ans: Its running fine without any error message.
It sounds like you have a package to run the DBCC Check DB, right? Can you manually run the package?
Ans: Yes Its dbcc checkdb. its giving the same error message while running manually as well.
March 27, 2010 at 5:36 am
GTR (3/26/2010)
Is it using same windows account as back up job maintenance task?
Is it using same windows account as back up job maintenance task?
Ans: Yes but it is not created through maintenance plan. Agent raising error message for Job which are created through maintenance plan.
There are other jobs for log shipping and mirroring but those are running successfully with out any problem. i am facing the problem for jobs which have created through maintenance plan.
Server Details:
Sql server 2005 standard version
32 bit
service pack 1 available.
Two instance have been installed in the server.
March 27, 2010 at 7:33 am
Hi
By any chance did you change the sql server agent process account using windows service manager?
March 27, 2010 at 8:46 am
vmssanthosh (3/27/2010)
HiBy any chance did you change the sql server agent process account using windows service manager?
No.i did not.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply