怎样删除PeopleSoft进程服务器定义

最新推荐文章于 2020-03-18 16:46:07 发布

weixin_30693183

最新推荐文章于 2020-03-18 16:46:07 发布

阅读量143

点赞数

原文链接：http://www.cnblogs.com/eason-liu/p/7136097.html

版权

比如在克隆环境时候，把生产的环境克隆到DEV环境，你可能会在进程调度服务器中看到了生产的进程服务器，例如：你可能会在进程调度的时候选择一个server，但是这个server并没有在psadmin下创建domain，有些时候，他可能会带来运行时错误。

在PIA没有更好的办法删除进程服务器，以下以PSNT2为例，需要在plsql中运行：

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

通过该方法你可以使你的进程服务器列表特别干净，因为没用的进程服务器都可以删掉。/(ㄒoㄒ)/~~

转载于:https://www.cnblogs.com/eason-liu/p/7136097.html