在DataStage中job不能刪除,如果試著編譯又出現如下錯誤:
Error calling subroutine: DSR_EXECJOB (Action=1); check DataStage is set up correctly in project ETUDES
(Subroutine failed to complete successfully (30107))
+
(40503) A call to an OLE server has failed, or a runtime error occured within the ole itself.
解決辦法:
1 首先運行命令:DELETE FROM DS_JOBS WHERE NAME = 'JobName'
2 再運行DS.CHECKER ,注意要運行DS.CHECKER必須要有exclusive access到project
,通過如下命令可以看到有誰還連接到了服務器:netstat -a |grep dsrpc