Archives of the TeradataForum
Message Posted: Fri, 13 Oct 2006 @ 18:13:53 GMT
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?
Appreciate any suggestion/help.
Thanks, in advance!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|