update to correct variable (#407)

GoogleCloudPlatform · May 13, 2024 · 0ea628c · 0ea628c
1 parent 85a0f24
commit 0ea628c
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/scripts/optimization/daily_reservation_analysis.sql b/scripts/optimization/daily_reservation_analysis.sql
@@ -116,7 +116,7 @@ FROM
                 FROM
                     `region-us`.INFORMATION_SCHEMA.JOBS_BY_ORGANIZATION jbo
                 WHERE
-                    DATE(jbo.creation_time, "US/Central") >= CURRENT_DATE - var_n_days
+                    DATE(jbo.creation_time, "US/Central") >= CURRENT_DATE - num_days_to_scan
                     AND jbo.end_time > jbo.start_time
                     AND jbo.error_result IS NULL
                     AND jbo.statement_type != 'SCRIPT'