SparkJun
Databricks Employee
Databricks Employee

It doesn't seem like this can be done through the DLT autoloader. Particularly you require an automatic stop without manual intervention. You can write a custom Structured Streaming job and use a sequence-checking logic, and foreachBatch to process incoming files and detect missing IDs.