I need to pass a parameter to a job. It is my understanding the best way to do this is to create a table that stores the parameter and then call on that to create the parameter in the job.
I have an Access front end that runs a stored procedure. Can I have that stored procedure create a temporary table to save the data in? Or is the table only available until the stored procedure is finished executing?
Maybe I can start the job from the stored procedure and use the parameter during the execution of the stored procedure?