Job running, but not starting

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Pierre
Participant
Posts: 66
Joined: Thu May 24, 2007 7:16 am
Location: Paris

Job running, but not starting

Post by Pierre »

Hi,

I have a job (Multi instance, with unique invocation, launched by a Job control) that runs every day without any problem, takin less than 1 sec.

It contains one SQL Server IN, one SQL Server LKP, and two SQL Server Outputs.

This morning, it was still running after more than 4 hours, with 0 lines :!:

After stopping and reseting it, I used "Wiev Data" on SQL Server IN and SQL Server LKP. It shows data without problem (58 lines for SQL Server IN, 1 for LKP).

Restarting the job gave the same result (running, but not working).
Finally, after stopping it again, I cleared locks and logged out, re-compile and restart the job, and it worked fine.

Does anyone have any idea about what happened :?:
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No, and you've destroyed the evidence.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply