diff --git a/db/migrate/20250910083751_add_last_scheduled_run_at_to_ci_pipeline_schedules.rb b/db/migrate/20250910083751_add_last_scheduled_run_at_to_ci_pipeline_schedules.rb
new file mode 100644
index 0000000000000000000000000000000000000000..3a44b10634a6df377301d60cd8e614733e782ff3
--- /dev/null
+++ b/db/migrate/20250910083751_add_last_scheduled_run_at_to_ci_pipeline_schedules.rb
@@ -0,0 +1,12 @@
+# frozen_string_literal: true
+
+class AddLastScheduledRunAtToCiPipelineSchedules < Gitlab::Database::Migration[2.3]
+  milestone '18.4'
+
+  # rubocop:disable Migration/Datetime -- We are keeping it the same as next_run_at
+  # which doesn't include the timezone.
+  def change
+    add_column :ci_pipeline_schedules, :last_scheduled_run_at, :datetime
+  end
+  # rubocop:enable Migration/Datetime
+end
diff --git a/db/schema_migrations/20250910083751 b/db/schema_migrations/20250910083751
new file mode 100644
index 0000000000000000000000000000000000000000..5b3fa05ba341e8f2b7597de4ba89ddb3ea70c5fa
--- /dev/null
+++ b/db/schema_migrations/20250910083751
@@ -0,0 +1 @@
+3a25dcd53bce2eb8f951d4d9dd5dec114ebad5042ba7a00d964502bfd9878268
\ No newline at end of file
diff --git a/db/structure.sql b/db/structure.sql
index 7e64c91d5bd6f202ae0fb112a7865a95ccf7a950..3ba4d1b25fada92b8d7cf904a9f0ef33e4a44659 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -13282,6 +13282,7 @@ CREATE TABLE ci_pipeline_schedules (
     active boolean DEFAULT true,
     created_at timestamp without time zone,
     updated_at timestamp without time zone,
+    last_scheduled_run_at timestamp without time zone,
     CONSTRAINT check_4a0f7b994d CHECK ((project_id IS NOT NULL))
 );