Page 1 of 1
Job gets stuck in Running status
Posted: Tue Aug 16, 2011 9:22 am
by gooogle
I created a job that loads a SQL > Transformer > Netezza table, after truncate & loading the table, the jobs gets stuck in the running status in director after loading the target table.
Any ideas ...
Posted: Tue Aug 16, 2011 9:26 am
by chulett
First task would usually be to trace the processes on the database side, see if there are locks / blocks there causing the 'hang'.
Posted: Tue Aug 16, 2011 12:52 pm
by gooogle
What exactly should I check ...
The job is still getting stuck in the Running status.
Posted: Tue Aug 16, 2011 1:28 pm
by chulett
"On the database side" means you have your DBA check for you. Let them know what table(s) it is accessing and/or the connecting user.
Posted: Mon Aug 22, 2011 1:47 pm
by vijaykumarpj
Also, try clearing the status of the job, thru DS Director.. then, re run the job.
Posted: Mon Aug 22, 2011 3:18 pm
by chulett
You would only do that if you knew the job was not actually running.
Re: Job gets stuck in Running status
Posted: Mon Aug 22, 2011 6:36 pm
by SURA
Check the version compatibility.
DS User