Archives of the TeradataForum

Message Posted: Tue, 19 Oct 2004 @ 12:41:53 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

This information is stored in IOS_SCHD_TASKS and IOS_TASK_SVR_ASGN (both should show the same values), you will need the DivID and JobID of the job(s) you are looking for. Depending on the version of CRM and job type you are looking up, there may be multiple tasks that will need to be summed to give you a total execution time.

	<Prev	Next>		<<First	<Prev	Next>	Last>>