Archives of the TeradataForum

Message Posted: Fri, 13 Oct 2006 @ 18:13:53 GMT


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

Subj:		Need script for killing sessions automatically for particular user at particular time

From:		Afreen, Sazia

Case: Need to kill any User1 (report job) session automatically that is blocking User2 (Load job) after midnight.

With Teradata Manager, we can have blocked session notification and can kill that according to time specified (in minutes).

We are not seeing any way of doing the following in this case with Teradata Manager:

-specifying the user names (reporting user (user1) blocking loading user (user2))

-way of setting up the specific time frame for this task (after midnight though early morning)

-and the whole process needed to be automated

Do we need to move to scripts? Is there any available/sample script for such job or we need to create one? How such script can be created and how can we make it work?

Need HELP!

Appreciate any suggestion/help.

Thanks, in advance!

Sazia


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