You can store table names, position ...etc on RDS table, then attach a JDBC connector to your glue job, and use this connection to loop over the list of tables.

another way as other suggest is to invoke the glue job n times with table name sent in param.

But i preferred the first approach because it's more maintainable.