Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Transformation job takes way longer when run on its own

I've noticed I have one job, TransformationJobX, where when I run it as part of a scheduled job that also runs many other jobs, it consistently takes about 3-4 minutes to run.

But when I am just doing development/testing, and I run TransformationJobX on its own, it consistently takes about 30 minutes to run! Weird.

As far as I can tell, all other things are the same. Same "environment." No other jobs running concurrently. Same starting conditions -- it truncate a table and then loads about 500,000 rows from scratch. The table is very wide, with many columns, including many text columns.

Any idea why it takes so long when I run it own its own, compared to when it's run in a sequence with many other jobs? (And, can I make it faster when I run it on its own?)

1 Community Answers

Matillion Agent  

Craig Rouse —

Hi Kevin,

Would you send us 2 things first:
Select Help → Support Information. Copy and paste that info in reply.
Select Admin → Download Server Log. Attach this log to the reply.

Prior to sending downloading the log, can you run the job both ways, first where it take a long time, second when it runs faster?

Thanks,
Craig

Post Your Community Answer

To add an answer please login