path: root/Software/Visual_Studio/Notes/Tango.Notes/DB/Fix Job Corrupted Runs Start Time.sql

UPDATE JOB_RUNS SET START_DATE = ACTUAL_START_DATE WHERE START_DATE = '0001-01-01 00:00:00.000' AND ACTUAL_START_DATE IS NOT NULL
UPDATE JOB_RUNS SET START_DATE = END_DATE WHERE START_DATE = '0001-01-01 00:00:00.000' AND ACTUAL_START_DATE IS NULL