There comes a scenario where I have a Parallel Routine (Transform Function) which Backs out the data in case of fatal error. It is sql script deleting the rows before loading fresh data.
I need to run it from with in my pre-existing job(s).
How can I get it working??
What I tried so far:
I tried
Adding this code in Job Control section of my job properties
Is it the wrong way to do///// Or I should be running it from some other place//// Any other thing I am missing.Answer =
BackOutScript(USERNAME,PASSWORD,INSTANCE,PATH,TABLENAME)
Any input will be appreciated.
Thanks and regards,
Munish