删除PeopleSoft Process Scheduler服务器定义

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' ;

 

转载于:https://www.cnblogs.com/aGameOfCode/p/10512496.html