Spark Sql Jobs

HI Team,

I need one favor on spark sql jobs.

I have to 200+ spark sql query running on 7 different hive table.

How can we do this in one jar file to execute all 200+ spark sql jobs.

currently we are managing 7 jar files for each tables.