SQL Agent

Question

Post reply

SQL Agent

sudhakara

SSCrazy Eights

Points: 9425
More actions
March 26, 2010 at 12:40 pm

#217189

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?.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

GregoryF SSCertifiable Points: 6296 More actions · Answer 1

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!

GTR SSCertifiable Points: 7977 More actions · Answer 2

GTR

SSCertifiable

Points: 7977

March 26, 2010 at 3:11 pm

#1140790

Is it using same windows account as back up job maintenance task?

EnjoY!

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 3

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.

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 4

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.