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.
Sequence Error
Moderators: chulett, rschirm, roy
How Do You pass the parameters to the jobs?
Do the jobs use the same parameter-sets? Or do you pass the parameters from the parametersets to individual job-parameters one by one?
Did you change the parameter-set after you last compiled any of the jobs?
Do the jobs use the same parameter-sets? Or do you pass the parameters from the parametersets to individual job-parameters one by one?
Did you change the parameter-set after you last compiled any of the jobs?
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon