删除PeopleSoft Process Scheduler服务器定义

时间:2021-08-07 14:45:11
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' ;