RE: Executing concurrent exports from single Windows batch file

RE: Executing concurrent exports from single Windows batch file

 

  

Yep. Works fine. Here's code snippet from my monitor_databases_alive.bat script:

for %%I in (%SIDLIST%) do (
echo %SCRIPT_NAME%: Checking availability of '%%I' ...
start /LOW /MIN cmd /B /C %DBA_CMD%\monitor_db_alive.cmd %%I
sleep 1
)

This spawns about 6 - 12 simultaneous threads (due to the "sleep 1", which I added to prevent a problem I call "cross-threading").
Todd Pepling
[Email address protected]
724-766-3492

________________________________

From: jherrick [mailto:oracledba-ezmlmshield-x30665266.[Email address protected]
Sent: Wed 10/31/2007 12:23
To: LazyDBA Discussion
Subject: Re: Executing concurrent exports from single Windows batch file




Have you tried a bunch of 'start' commands in the same batch script? i.e.

start exp user/[Email Address Removed] full=y file=whatever
start exp user/[Email Address Removed] full=y file=whatever
start /WAIT exp user/[Email Address Removed] full=y file=whatever

the trick is to put your longest running export as the last one...then the
batch script will finish when the last one finishes.

Cheers



Oracle LazyDBA home page