MYSYSAD.COM

Terminate or Kill a Sybase Process

· Databases · System & processes

From time to time, you may need to kill an internal Sybase process or processes. This requires using Sybase’s sp_who command ascertain the process identification or PID. Then you will use the kill command. Here is a run of how to kill a process via SQL.

1> sp_who
2> go
1> kill PID
2> go

I always like to reconfirm that the process or processes was/were killed.

1> sp_who
2> go

For a specific login
1> sp_who esofthub
2> go
1> kill esofthub_PID
2> go