SQL to delete process scheduler server definition

How to Delete PeopleSoft Process Scheduler Server Definitions

In some cases like database refresh, when PTools tables also get refreshed – you may end up getting unwanted process scheduler data in your Process Scheduler tables.

For example, you may end up getting a process scheduler server name, which does not exist in that instance. Sometimes it may cause issues like a process not running because a previous zombie instance exists in process scheduler table or when running a particular process, it may give you an error saying that server definition does not exist.

There isn’t a great way to delete PeopleSoft Process Scheduler server definition from online.

Here are the SQLs you’ll need to run via SQL tool or you can even use a DMS script to delete the process scheduler definitions.

The below script is for server name PSNT2, which you’ll need to replace with the appropriate name of the server name in your case.

DELETE FROM PS_SERVERDEFN WHERE SERVERNAME= ‘PSNT2’ ;
DELETE FROM PSSERVERSTAT where SERVERNAME = ‘PSNT2’ ;
DELETE FROM PS_SERVERCLASS WHERE SERVERNAME= ‘PSNT2’ ;
DELETE FROM PS_SERVEROPRTN WHERE SERVERNAME= ‘PSNT2’ ;
DELETE FROM PS_SERVERACTVTY WHERE SERVERNAME= ‘PSNT2’ ;
DELETE FROM PS_SERVERMESSAGE WHERE SERVERNAME= ‘PSNT2’ ;
DELETE FROM PS_SERVERNOTIFY WHERE SERVERNAME= ‘PSNT2’ ;
DELETE FROM PS_SERVERPURGLIST WHERE SERVERNAME= ‘PSNT2’ ;
DELETE FROM PSPRCSQUE WHERE SERVERNAMERQST= ‘PSNT2’ ;
DELETE FROM PS_CDM_TRANSFER WHERE SERVERNAMERUN= ‘PSNT2’ ;
DELETE FROM PSPRCSRQST WHERE SERVERNAMERQST= ‘PSNT2’ ;
DELETE FROM PS_SERVERCATEGORY WHERE SERVERNAME = ‘PSNT2’ ;

You can even use this script to keep your process scheduler definition table clean and delete all the unwanted and unused servers.

Apurva Tripathi
 

>