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
Job remains in running state
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 88
- Joined: Wed Apr 05, 2006 1:04 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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>