From 00a491d93733d4625ad329b2ba8237f445364b3f Mon Sep 17 00:00:00 2001 From: Mirta Date: Wed, 30 Dec 2020 16:39:52 +0200 Subject: merge --- .../Notes/Tango.Notes/DB/Fix Job Corrupted Runs Start Time.sql | 2 -- 1 file changed, 2 deletions(-) delete mode 100644 Software/Visual_Studio/Notes/Tango.Notes/DB/Fix Job Corrupted Runs Start Time.sql (limited to 'Software/Visual_Studio/Notes/Tango.Notes/DB') diff --git a/Software/Visual_Studio/Notes/Tango.Notes/DB/Fix Job Corrupted Runs Start Time.sql b/Software/Visual_Studio/Notes/Tango.Notes/DB/Fix Job Corrupted Runs Start Time.sql deleted file mode 100644 index 9467a8cf1..000000000 --- a/Software/Visual_Studio/Notes/Tango.Notes/DB/Fix Job Corrupted Runs Start Time.sql +++ /dev/null @@ -1,2 +0,0 @@ -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 \ No newline at end of file -- cgit v1.3.1