Issue: After DB restore from PROD to NON-PROD environment, Data maintenance activity and Process automation wasn't working
Solution: Change batch job "Process automation background processes system job" status from WITHHOLD to Waiting
Issue: After DB restore from PROD to NON-PROD environment, Data maintenance activity and Process automation wasn't working
Solution: Change batch job "Process automation background processes system job" status from WITHHOLD to Waiting
Refrence: sys.dm_db_missing_index_details (Transact-SQL) - SQL Server | Microsoft Learn