Re: Inactive time for jobs in DSPW condition

Leif,

>Getting and working with the TDE is working "below" the MI (and
>thus strictly speaking off topic :-). You only want to go there if you
>*really* need to. What is the problem you are trying to solve?

I have a utility which is kinda like WRKUSRJOB, and for interactive jobs in a
DSPW condition, I wanted a column which showed how long that session had been
waiting -- ie, how "active" or recent is the last usage.

It is not critical; I just thought it would be a nice addition and presumed the
information should be available somewhere, but couldn't find it.

Secondarily, I have a job which I run prior to nightly unattended backups.  It
checks what jobs are active, and if there are interactive jobs sends them a
break message and delays.  After a few iterations, it forces them off to start
the backup.  If I could tell how long it had been since the last WS I/O
transaction, I'd have a better indication if it is safe to just end the job
immediately or increase my delay times or number of warnings.

Doug