Archives of the TeradataForum

Message Posted: Mon, 07 Dec 2009 @ 11:13:44 GMT

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

Hi Souyma,

You can find the nuber of 'logged on' jobs of each type by querying dbc.sessioninfo. Look in the LogonSource column for the relevant program name (e.g. MLOAD) and substring from Position 15. Group by the resulting substring and that will identify each unique job.

The utilities themselves don't check a system table to find out if there are too many running. This return code is passed back by the DBMS which keeps a track of how many such jobs are running in memory structures.

Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

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