Sequence Error
Posted: Wed May 09, 2012 8:38 am
Ok..So I have a typical problem, which am not able to pass through may be someone can help.
I have a sequence for the jobs and its parameterised.
I have 2 sets of parameters, 1 for sources and the other for the target DB's and connection details, which includes the parameters for DB's, schemas, DSN etc.
Now, when I run the sequence, which say point to/from DB_1, randomly it will generate error Error calling DSSetParam(Pset.DB_X), code=-3 [ParamName does not reference a known parameter of the job]
so, it refers to some other DB and says its not being used in the job. and ABORTS.
If I run the jobs individually then its fine, but with sequence it will ABORT.
Can please help me an insight on it. Thanks.
I have a sequence for the jobs and its parameterised.
I have 2 sets of parameters, 1 for sources and the other for the target DB's and connection details, which includes the parameters for DB's, schemas, DSN etc.
Now, when I run the sequence, which say point to/from DB_1, randomly it will generate error Error calling DSSetParam(Pset.DB_X), code=-3 [ParamName does not reference a known parameter of the job]
so, it refers to some other DB and says its not being used in the job. and ABORTS.
If I run the jobs individually then its fine, but with sequence it will ABORT.
Can please help me an insight on it. Thanks.