Error SID numbers
I was looking a specific error table (ps_e_s_payment_tbl and was wondering if one removes all rows from this table and the target table F_SF_PAYMENT, and when one runs this MDW job again, it pulls in the last error_sid for that table. Here is my question, if say someone truncates these 2 tables, how could one go about resetting the error_sid for PS_E_PAYMENT_TBL, if this can be done? Or can this not be done and one just has to continue with the next concurrent ERROR_SID number for the error table.
0