sheduling pakages as job fails

Question

sheduling pakages as job fails

shankar deokar

SSC Rookie

Points: 34
More actions
October 8, 2007 at 10:04 pm

#73767

Hi,
Can you help how to solve this error.
When I am sheduling pakages to run as job.
I am getting the error which get written in event log as follow.
The description for Event ID ( 208 ) in Source ( SQLSERVERAGENT ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: LD1_DET_V, 0xF6417DA90CE3F3489643B4B716958595, Failed, 2007-10-08 11:10:00, The job failed. The Job was invoked by Schedule 128 (LD1_DET_V). The last step to run was step 1 (LD1_DET_V)..
--shankar

Viewing 5 posts - 1 through 4 (of 4 total)

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

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

I can't tell what caused the failure from what you've posted. If you could enable package logging in the DTS package and post what that shows after the next failure, we'd be better able to help.

Greg

shankar deokar SSC Rookie Points: 34 More actions · Answer 2

Step Error Source: Microsoft OLE DB Provider for SQL Server

Step Error Description:Login failed for user 'sa'.

Step Error code: 80040E4D

Step Error Help File:

Step Error Help Context ID:0

Above is error in pakage log..

--Shankar

Lowell SSC Guru Points: 323507 More actions · Answer 3

it's all there:

n:Login failed for user 'sa'.

you must have mis typed the password. reenter it, and if permissible, run it right now on demand, instead to confirm it runs.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

shankar deokar SSC Rookie Points: 34 More actions · Answer 4

you mean to say pakage run manually does not check saa password & when it run it's check for password. I guess I am put the password in pakage correctly that why it runs mannually. when shedule as a job then pakage fail.

--Shankar