ETL jobs should re run till some conditions meet

[Former Member]

Hi,

Some times the data service server is unable to connect to the source server and the ETL job throw error.

I need, the the job have to try till to getting the connection and have to run successfully.

How to go about it?

Thanks.

Regards,

Kathir

[former_member205887 · Accepted solution]

1) Place a try catch blocks.

2) In Catch block script call the same job( use exec function) after certain interval (Use Sleep function to maintain time)

-- Balakrishna

[Former Member · Accepted solution]

Hi Bala,

How to use exec function to call the job?

Kathir

[former_member205887 · Accepted solution]

Use below kind of command considering your OS

exec('cmd.exe','C:\\DS\Job.bat',1);

[Former Member · Accepted solution]

Thanks Bala.

Its working fine.

In one job, there are multiple work flows and if any one work flow failed, is there any option to re run the particular work flow instead of running the entire job.

Kathir

[former_member205887 · Accepted solution]

You can do that by having a pre and post script to update the job completion status and having a conditional workflow at each level, by doing this it will execute the entire job but will run only Workflows that were failed or not started.

[Former Member]

Hi Kathiravan PM,

Go to the management console and select the job name for which you want to the .bat file select the "Export execution command" it will creat a .bat file in your Data services installed folder, you can that from the exec command as said above by Balakrishna P.

Thanks,

Subbu CH.

[Former Member]

Its done Subbu.