Export to JDBC - not loading but Job completing
I have an export step that goes to JDBC database. We have another table in the database thats working and we have checked connection and it works.
When l load to my database it is saying it completed but you can clearly see 0 seconds at export stage (taking about 1 hour 47 mins to load 900K lines, 48 columns. There are no errors in log, it doesnt fail on job.
Is there anywhere l can review to find out why its not loading?
Do l need to make sure fields in schema have exact what table has?
So export step
Key columns has all the 48 columns in sequence of the database.
Run job - all steps run in a second (1000 rows)
but its not doing export step
Transform 7 is the last step before export (1000 lines so quite quick)
On a previous one it went for over an hour
stated complete and hasnt worked but no error in log on server and the steps say export 0 seconds. Its not actually doing anything
any ideas on what l need to do or look for? I did expect errors on fields to database but no errors listed
This is quite urgent to get it working, any ideas would be a great help