Passing values between jobs (routines) in a sequence
Posted: Thu May 19, 2011 11:04 pm
I need to build a job sequence that contains few jobs and I need to pass a value from one to the other. Job A calls an SP that returns a value. This value is used as an input parameter in the job B. How best to implement this scenario?
In the past I used sequential files to store values between jobs in a sequence, but I wonder whether there is any better way to do it and keep the file system out of the picture.
In the past I used sequential files to store values between jobs in a sequence, but I wonder whether there is any better way to do it and keep the file system out of the picture.