Script for cancelling a certain session

[silhanek]

Up until now I have had an Administrative Command Schedule to run cancel session all at 8am. Due to some timezone issues now, I need to be able to cancel certain sessions a few hours earlier, but let others continue to run until 8am.



I'm able to use the following line to get the session id's, but don't know how to use them in a cancel session command.

select session_id from sessions where client_name='*******'



Thanks for any help,

Virgil