Oracle Scripting

[piconel]

I am using an Oracle (8) database, with Tivoli Service Desk as the application. If the application crashes when a user has a 'problem ticket' open, the application sees that ticket as locked. The fix is fairly easy... sign into Oracle, type the following command
UPDATE PROBLEMS SET ACTIVE_WITH = NULL WHERE PROBLEM_ID='WHQ-00000000'; , and type Commit; My concern is giving 'adventurous' Level 1 associates the EDIT userid and password. Is there an 'easy' script that can be created that they can execute, fill in the ticket number '00000000', and the the script will execute the sign on, command line, commit, and complete the process?

Thanks for any help that you can provide...

Leah Picone
Computer Aid, Inc.


Leah_Picone@compaid.com

 

[ekrueger]

An easier fix would be to program the SQL into KML and give the users a button or menu drop down to run that command. You could then give them a dialog box that they could enter the problem number into to unlock it. You must emphasize to the techs to actually call the person that it is locked with to make sure they don't have the ticket minimized on their screen or something like that...