Siebel EIM >  Activity Delete example

The IFB file should look like this. You can change the process name
and batch range.

[Siebel Interface Manager]
PROCESS = DELETEACT

[DELETEACT]

TYPE = DELETE
BATCH = 1000-3000
TABLE = EIM_ACTIVITY

ONLY BASE TABLES = S_EVT_ACT

DELETE EXACT = TRUE
COMMIT EACH TABLE = FALSE
COMMIT EACH PASS = FALSE
ROLLBACK ON ERROR = TRUE

Save this file as actdelete.ifb

The insert SQL should be like this
insert INTO TABLE SIEBEL.EIM_ACTIVITY
act_activity_UID ,
ROW_ID ,
IF_ROW_STAT ,
IF_ROW_BATCH_NUM
)
values ( select activity_uid,
row_id,
'FOR_IMPORT',
'1000'
from siebel.s_evt_act where
activity_uid in ('activity_uid1','activity_uid1'));
commit;

The servermanager command would be in this format
srvrmgr /g i.p.address:2320 /e SRVRNAME /u sadmin /p password /c "run task for component EIM server
SIEBELSERVER with config=/commonfolder/actdelete.ifb, errorflags=1, traceflags=1, sqlflags=8,
ExtendedParams='BATCH_RANGE=1000 - 3000, PROFILE_FILE=/commonfolder/actdelete.log'"