Friday, June 12, 2009

Reset Process Status

When the process has errored and you can't remove it from the process monitor.
UPDATE PSPRCSRQST
SET RUNSTATUS = '2'
,DISTSTATUS = '5'
WHERE PRCSINSTANCE = 191596
/
-- DISTSTATUS OF 5 = POSTED TO WEB
-- RUNSTATUS  OF 2 = DELETE

No comments:

Post a Comment