Delete all Projects & Agents in BCC

Delete all Project & Agents in BCC


--Agents Clean UP
delete from EPUB_TR_AGENTS;
delete from EPUB_TARGET;
delete from EPUB_TL_TARGETS;
delete from EPUB_PRJ_TG_SNSHT;
delete from EPUB_PR_HISTORY;
delete from EPUB_AGENT_TRNPRT;
delete from EPUB_INCLUD_ASSET;
delete from EPUB_PRINC_ASSET;
delete from EPUB_AGENT;
delete from EPUB_PR_TG_STATUS;
--Project Clean UP
delete from EPUB_PROJECT;
delete from EPUB_PR_TG_AP_TS;
delete from EPUB_DEPLOYMENT;
delete from EPUB_PR_TG_DP_TS;
delete from EPUB_PROC_HISTORY;
delete from EPUB_PR_TG_DP_ID;
delete from EPUB_INT_PRJ_HIST;
delete from EPUB_PROC_TASKINFO;
delete from EPUB_WORKFLOW_STRS;
delete from EPUB_IND_WORKFLOW;
delete from EPUB_PROCESS;
delete from EPUB_PR_HISTORY;
delete from EPUB_PROC_HISTORY;
delete from avm_asset_lock;

1 comment:

  1. Above list is great, only one addition to it though. I keep seeing child constraint issues, here is what works every time for me...

    --Agents Clean UP
    delete from EPUB_TR_REP_TBL_MP;
    delete from EPUB_TR_AGENTS;
    delete from EPUB_TARGET;
    delete from EPUB_TL_TARGETS;
    delete from EPUB_PRJ_TG_SNSHT;
    delete from EPUB_PR_HISTORY;
    delete from EPUB_AGENT_TRNPRT;
    delete from EPUB_INCLUD_ASSET;
    delete from EPUB_PRINC_ASSET;
    delete from EPUB_AGENT;
    delete from EPUB_PR_TG_STATUS;

    --Project Clean UP
    delete from EPUB_PROJECT;
    delete from EPUB_PR_TG_AP_TS;
    delete from EPUB_DEPLOYMENT;
    delete from EPUB_PR_TG_DP_TS;
    delete from EPUB_PROC_HISTORY;
    delete from EPUB_PR_TG_DP_ID;
    delete from EPUB_INT_PRJ_HIST;
    delete from EPUB_PROC_TASKINFO;
    delete from EPUB_WORKFLOW_STRS;
    delete from EPUB_IND_WORKFLOW;
    delete from EPUB_PROCESS;
    delete from EPUB_PR_HISTORY;
    delete from EPUB_PROC_HISTORY;
    delete from avm_asset_lock;

    Regards,
    - fs

    ReplyDelete