Time delay between two dos commands

0.00/5 (No votes)

See more:

Hi,

I am trying to include a delay of 120 secs between following two DOS commands in .bat script:

COPY \\CDFS23001\\SOURCE\ORG\*ACCOUNTS*.xml \\CDFS23001\\SOURCE\TGT\

TIMEOUT /T 120 /NOBREAK

dir /b \\CDFS23001\\SOURCE\TGT\*ACCOUNTS*.xml > \\CDFS23001\\SOURCE\TGT\List_Accounts.txt

The above timeout is working perfectly when directly executing the .bat script directly or through command prompt but doesn't works when running through a task in other tool (command task in ETL tool - Informatica Powercenter).

The COPY and DIR commands are working fine but only the TIMEOUT doesnt work when batch file called through an external task.

I have also tried PING, CHOICE, PAUSE, SLEEP none of them works here when .bat file called though external task.

Can anyone please suggest me what might be the issue or any other way to include a time delay between above two commands.

Thanks in advane

What I have tried:

I have also tried PING, CHOICE, PAUSE, SLEEP none of them works here.

Posted 3-Jul-18 23:26pm

Aditya_ETL

Updated 5-Jul-18 9:38am

Add a Solution

Comments

Alan N 4-Jul-18 6:22am

Before any one can attempt to answer they will need to know what you mean by "when running through a task in other tool"

Aditya_ETL 4-Jul-18 6:25am

Thanks Alan, I have updated the question and included the tool details

Richard MacCutchan 4-Jul-18 7:40am

You need to gather more information to find out exactly what happens when you run it through the tool. Add some echo statements and capture all the output.

Sajjid Atta 4-Jul-18 16:33pm

I've Never worked on your tool but try this command. That may work
waitfor SomethingThatIsNeverHappening /t 100

Aditya_ETL 5-Jul-18 5:18am

Wonderful..!!!! It worked, Thanks a ton

Regards,
Aditya

Dave Kreskowiak 5-Jul-18 16:37pm

The problem with using an arbitrary delay is that it works on the current network load and number of files. When the network gets loaded down with other traffic and your number of files increases, this delay will, again, fail.

Using a timeout is a bad-aid fix and does NOT address the root cause of the problem.

Oh, and AGAIN, the COPY command is a blocking call. The next line in the batch file will NOT execute until every byte of every file has been copied over to the destination.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Rick York	80
Dave Kreskowiak	50
Richard MacCutchan	40
Richard Deeming	40
Graeme_Grant	40

Pete O'Hanlon	1,830
OriginalGriff	1,365
Graeme_Grant	895
Richard Deeming	798
Dave Kreskowiak	684

Time delay between two dos commands

Add your solution here

Preview 0

Time delay between two dos commands

Add your solution here

Preview 0

Existing Members

...or Join us