There is a solution for that.

Indeed jobs are run on separated session.

The problem, that you cannot pass parameters to the stored procedure (while they are kept in other session). i.e. whether you add in a temporary table and do rollback at the end.

• Save the parameters in a temporary file.

• Add a stored procedure, that can add data into the temporary file and call to the job.

• Add a stored procedure that the job can call (i.e. the latest file found).

  • In that stored procedure - run sql with the parameters read from the file.

For that solution - any call to the special stored procedure (that calls the job) won't be interfered by any transactions.