Hi All,
Is there a way I could set persistent connection for datastore?.
The passwords in our production edw changes every month and when it happens, the jobs which are running at the time of change are stopped with success message…
Lets say, a job is running for 1000 records but when it was processing 500th record the password changed… What happens is the job ends at 500th record with a success message Two issues here…
- How to make the job fail, as it had not parsed 1000 records?
- Is there a way I can make connection persistent… What I mean is, when the password changes for 500th record, still the job completes till 1000 records and finishes successfully. The next run of the job should fail as the password has been changed. Is this possible? If yes, how?
Appreciate for looking into this.
Thanks!!
adbas (BOB member since 2010-01-12)