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: Back-Up
    ... When you login your profile includes setting up the ... This does not happen for a scheduled job unless you have the NET ... The job is ran as administrator and the security tab shows groups ... The server is up-to-date in terms of updates. ...
    (microsoft.public.windows.server.general)
  • 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)
Loading