Meaning, it runs fine when you start it but when you use a Job Activity stage in a Sequence job to launch it, it fails? And the connection information your stored procedure uses are parameterized? The obvious first thing to check is to verify that your parameters and values are A) correct in the Sequence job and B) being passed to the job correctly.
Check both logs to verify.
-craig
"You can never have too many knives" -- Logan Nine Fingers
You may have a typo in your tnsname.ora file on the DataStage server or a typo in the stage properties. Double check your job logs that all parameters resolved correctly and double check your stage properties for typos.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Hi Eric,
Some one has changed the tns entries, still it's a mistry who has changed, after u r suggestion once ag we ain we checked everything and replace the correct one