I was running an SSIS package SQL Agent job when the virtual server was stopped hard. Now the Report > All executions shows that job as still running, even though it is not. I believe that the job was not able to update the status to "Unexpected termination" before it died so there is a flag or a record missing from a table in the SSIS DB.
Is there a way to tell SQL Server SSIS Reports that the job is not running? Some record I can write, flag I can set, Etc?