Run multiple jobs in one session

[leolr02]

SO: Windows 11 Pro
PostgreSQL: 15.2

Is possibly to run multiple jobs in only one session?, I use a postgres function for create multiple jobs for this:
In one job I connect to remote database using PROGRAM command kind something like that:

SELECT timetable.add_job('connect to remote host', '* * * * *',
job_kind := 'PROGRAM'::timetable.command_kind ,job_command := 'psql',
job_parameters := ('["host=remotehost dbname=mybd user=someuser port=5432 password=somethingpassword"]')::jsonb,
job_self_destruct := true
) INTO employeeTypesJob;

Then I need to copy multiple sql files to some tables in remote database:
SELECT timetable.add_job('copy remote table', '* * * * *', job_kind := 'PROGRAM'::timetable.command_kind, job_command := 'psql', job_parameters := ('["\COPY schema.remote_table FROM '''||dynamicSomePath||'''"]')::jsonb, job_self_destruct := true)
INTO copyJob;

Is possible to run this jobs in only one session? or exists some way to run nested jobs?

In MacOS is easy to run the copy in only one job using -c parameter in the connection string, but in Windows this is not possible

[pashagolub]

of course, it should be one chain with several tasks. Check Download example on how to do it

[pashagolub]

Please, check documentation on details of command, task and chain

[leolr02]

Thanks for the quick response!, I will check the example :)