How to delete a process scheduler server definition

There is no delivered method to delete a process scheduler server definition from the PeopleSoft system tables. It will need to be done manually.

To remove it in process monitor, the following command should be issued:

delete from PSSERVERSTAT where SERVERNAME = ;

If the server definition has not been used and needs to be removed entirely, then use the following SQL.

delete from PS_SERVERCLASS where servername = ;
delete from PS_SERVEROPRTN where servername = ;
delete from PS_SERVERDEFN where servername= ;

Server definition that has been used, needs to be removed from the following tables as well
PS_SERVERACTVTY
PS_SERVERMESSAGE
PS_SERVERNOTIFY
PS_SERVERPURGLIST
PSPRCSQUE
PS_CDM_TRANSFER
PSPRCSRQST
This resolution for PeopleTools 8.4 and above.