python run multiple file paralaly

[mg24]

Hi Team,

I have sql_table.py files, Which I use to extract sql table into csv files.
sql_table.py files requires two parameter. 1) SQL_Table name , 2) Output_Folderpath

I run py file via command line,
I Open 10 command line screen, Run .py files in different screen , only change paramater, (tblname,foldepath)

it works parallely.


How to run parally by calling single file , and it will run all files.

	
	 .PY FILES     TableName  FolderPath	
python sql_table.py   tbl_1    D:\\Out\tbl_1
python sql_table.py   tl2_2	 D:\\Out\tbl_2	
python sql_table.py   tl3_3	 D:\\Out\tbl_3	
python sql_table.py   tl3_4	 D:\\Out\tbl_4	
python sql_table.py   tl3_5	 D:\\Out\tbl_5	
python sql_table.py   tl3_6	 D:\\Out\tbl_6	
python sql_table.py   tl3_7	 D:\\Out\tbl_7	
python sql_table.py   tl3_8	 D:\\Out\tbl_8	
python sql_table.py   tl3_9	 D:\\Out\tbl_9	
python sql_table.py   tl3_10	 D:\\Out\tbl_10

[woooee]

Use multiprocessing. Pool can use all cores simultaneously, and will start/run a group of processes. https://www.codesdope.com/blog/article/m...in-python/

[deanhystad]

Why aren't you writing this as a shell script?