Job remains in running state

ketanshah123 · Post by **ketanshah123** » Fri Mar 26, 2010 6:34 am

Hi

In one of the jobs where I am just fetching some data from oracle table and inserting/updating it to sql server table. But whenever I run the job it just remain in running condition only and nothing happens. it it is not pulling data from oracle also. The last message in log I can see is

main_program: Starting step execution.

Any idea what exactly is happening ? How can I resolve this ?

Thanks in advance

ArndW · Post by **ArndW** » Fri Mar 26, 2010 7:10 am

Replace your target sql server stage with a Peek statement. Does your new job hang? If not, you need to check your sql server stage, otherwise you need to check your source SELECT statement.