back

When resetting an ETL process you need to change the following fields.

Field	Value
bookmark	Null
recordsRetured	0
totalRecords	0
status	notStarted (this will regenerate all the elastic indexes use with care, but nothing for mysql)
lastRun	null
result	null
pending	0
processedTo	0

For mysql you can use the code:

UPDATE <tableName> SET bookmark = NULL, recordsRetured = 0, totalRecords = 0, status = 'notStarted', lastRun = NULL, result = NULL, pending = 0, processedTo = 0 WHERE etl_type = '<etl_type>' AND communityId = '<_communityId>';