Re: Reading SysProcess System Table to find idle processes
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 09/25/02
- Next message: Sue Hoegemeier: "Re: Client Enterprise manager security"
- Previous message: Erick Thompson: "Can AD domains/forests (LAN & DMZ) share a DNS domain?"
- In reply to: Leon Parker: "Reading SysProcess System Table to find idle processes"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Tue, 24 Sep 2002 19:32:46 -0600
You can do something comparing the last_batch column to the
current date/time. You can then kill the spid returned where
the difference between current date/time and last_batch
exceeds whatever value you use to deem the spid as inactive.
-Sue
On Tue, 24 Sep 2002 12:07:26 -0700, "Leon Parker"
<lparker@lotobco.com> wrote:
>The column headings are a little confusing. What columns
>will give me the idle time for a process?
>
>Can I then set up a procedure/job to read this table every
>5 - 10 minutes and kill processes that have been inactive?
- Next message: Sue Hoegemeier: "Re: Client Enterprise manager security"
- Previous message: Erick Thompson: "Can AD domains/forests (LAN & DMZ) share a DNS domain?"
- In reply to: Leon Parker: "Reading SysProcess System Table to find idle processes"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
