Scheduled Job fails, but package runs successfully... -- sql server (microsoft)

None
1/25/2007 8:58:06 AM

Hi all,

I have a DTS Package which imports data from a different server. this
job is scheduled twice a day and at times the scheduled job fails with
an error... Not all times, only some times the failure occurs.

Description : MSHSRMNSUKP0056 (SQLSERVERAGENT[208]) - Action=Please see
Ops Doc - Section 3.3,Msg=SQL Server Scheduled Job 'PkgSPSDFactWeekly'
(0x9B9B951C2239BC4AB84D0BF1A38E3875) - Status: Failed - Invoked on:
2007-01-21 04:19:00 - Message: The job failed. The Job was invoked by
Schedule 113 (PkgSPSDFactWeekly2). The last step to run was step 1
(PkgSPSDFactWeekly).

The event log recorded a message saying...
Executed as user: APPSRV03\murram The step did not generate any output.
Process Exit Code -1073741819. The step failed

Can you please help me identify the problem?

Lee Boozer
1/28/2007 10:55:36 AM

Best bet - it sometimes has problems connecting to, or communicating with, that
"different server". The fact that it runs sometimes tells you there's nothing
wrong with that job or package itself. I'm betting step 1 has to connect to that
other server?

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server (microsoft)

sql server (microsoft) : Scheduled Job fails, but package runs successfully...