Hi,
I've created a set of jobs which require a date and time parameter. In the job, I've created a string parameter "extract_start_dt". In the job, if I set this parameter to "2004-10-01 00:00:01.000", the job will run okay. I've also generated a sequence to run all these jobs again using the "extract_start_dt" string parameter.
The problem is, the sequence gives me this error
DW03100sCertStaff..JobControl (@DW03103jCreatewrkTables): Controller problem: Error calling DSSetParam(extract_end_dt), code=-4
[ParamValue/Limitvalue is not appropriate]
when I try to run the sequence. As long as the parameter contains only the date, it will run but at soon as I try to put the time on it, it aborts. If I hardcode the date and time string in the job activity stage list of parameters, then again, it will run fine.
Has anyone else experienced this problem?
Thanks
Job Sequences and String Parameter
Moderators: chulett, rschirm, roy