Posted: Mon May 19, 2008 11:05 pm
Designer (I believe) ignores anything you give in Job Run Options and uses the defaults (set using Tools menu in Director).
There does not appear to be any mechanism in Director for recovering the run and warning limits with which a job was run, even when non-default values are given.
If you really want to hack the only place I've found the information is in the RT_STATUS record for the job (this gets marginally more complex if the job is multi-instance).where nnn is the job number from DS_JOBS.
There does not appear to be any mechanism in Director for recovering the run and warning limits with which a job was run, even when non-default values are given.
If you really want to hack the only place I've found the information is in the RT_STATUS record for the job (this gets marginally more complex if the job is multi-instance).
Code: Select all
SELECT @ID FMT '40L', EVAL "@RECORD<18>" WARNLIMIT FROM RT_STATUSnnn WHERE EVAL "@RECORD<1>" = 'JOB';