Restart Job at point of tJDBCInput error

[Anonymous]

I have a job where I am extracting a large data set(37 million records each refresh) from an external Vendor database via a JDBC connection.  I am using the bulk load component to insert the data into an oracle database.  I have set up the job to bulk load into the oracle database in wk_end_dt increments.
However sporadically I receive the following error in the tJDBCInput component.  I have added an additional JDBC connection to open and close the connection after each wk_end_dt load, but I am wondering how I can restart the job at the wk_end_dt it left off at when I receive this error.  Anyone have any suggestions on how to set this up in my job?
Here is the error I receive.  TEIID30504 is the name of the external database I am pulling data from  







Job

[Anonymous]

Hi,
What's the error message you are facing? Could you please post you whole job design screenshot into forum?
Best regards
Sabrina

[Anonymous]

I re-posted the two errors I am getting in the original post. 
The first error is from the JDBCInput : "Error checking for a transaction"
The second error is from the JDBC Commit : "The transaction is not active"
Here is also the full set of screen shots from the Job

[Anonymous]

Full set of job images