Scheduled Job fails, but package runs successfully...

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?

.

Relevant Pages

  • Re: DTS job is not copying all the data but still the Job History shows Successful?
    ... >> servers every night using a DTS scheduled job. ... >> the tables on one of the destination server are empty. ... >> Martin Moustgaard ...
    (microsoft.public.sqlserver.server)
  • Re: Scheduled Job fails, but package runs successfully...
    ... Best bet - it sometimes has problems connecting to, or communicating with, that ... "different server". ... Ops Doc - Section 3.3,Msg=SQL Server Scheduled Job 'PkgSPSDFactWeekly' ... Schedule 113 (PkgSPSDFactWeekly2). ...
    (microsoft.public.sqlserver)
  • Question about sql job, SQL 7 versus upgrade to SQL 2000
    ... I just realized that I dont need to do anything because ... >I have a server that until yesterday had SQL 7 on it, ... It's a scheduled job to be run each night, ... upgrading to SQL 2000. ...
    (microsoft.public.sqlserver.server)
  • Job Fails - Security Issue
    ... I have a console application which I run from a server. ... remotely log on to the server and sumit the application it runs just fine. ... Is this drive not mapped when the scheduled job uses my login ID ...
    (microsoft.public.dotnet.languages.csharp)
  • DTS scheduled job slow
    ... DTS scheduled job used to run in less than 2 mins, ... from Sybase server to SQL 2000 server. ... Sybase Driver: SYODBASE.DLL ... PRD ...
    (microsoft.public.sqlserver.dts)