all groups > sql server dts > july 2003 >
You're in the

sql server dts

group:

DTS job fails before even calling the job


DTS job fails before even calling the job Sue McDermott
7/31/2003 12:59:16 PM
sql server dts: I have approx. 20 jobs that run over the course of a day
in my system (running 7.0)

Occassionally, jobs begin to fail even prior to execution.
This is the information in the 'show job steps' option in
the job history:

The step did not generate any output. Process Exit Code
128. The step failed.


There is nothing in the log file for the job because the
job never actually begins execution.

Thanks,
Sue
Re: DTS job fails before even calling the job Narayana Vyas Kondreddi
7/31/2003 9:45:40 PM
Just wondering if this is related to DTS in the first place. What exactly is
this job trying to execute? Could you post the commands from the job step?

I've seen similar errors coming from replication jobs, which is a result of
some replication DLLs missing or not being registered.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




[quoted text, click to view]
I have approx. 20 jobs that run over the course of a day
in my system (running 7.0)

Occassionally, jobs begin to fail even prior to execution.
This is the information in the 'show job steps' option in
the job history:

The step did not generate any output. Process Exit Code
128. The step failed.


There is nothing in the log file for the job because the
job never actually begins execution.

Thanks,
Sue


AddThis Social Bookmark Button