A scheduled database operation reports failure. The automation must remain retryable and diagnosable. Which behavior is best?

1. Retry destructive steps indefinitely without state
2. Always report success so the schedule remains green
3. Delete all logs after an error
4. Record structured failure details, distinguish retryable errors, and preserve safe resumption state