Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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!


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020