I have 2 sql stored procedures
one that passes a file name as an output parameter
the other that takes in a file name as an input parameter and performs an ftp
I would like to write (and then schedule) a job that would execute the first stored proc and use the output from the first stored proc as the input value to the other stored proc that would be executed another job step
Is this possible (pass output variable value to subsequent job step)????
From a reusability and error processing stand point, trying to avoid calling the second stored proc from within the first one