smgpulse007/missingrunids icon
public
Published on 5/1/2025
missingRunIDs

Prompts
Sample Data and Schema for Missing Run IDs
A sample prompt
/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP (1000) [Last_ExistingId]
      ,[Next_ExistingId]
      ,[Num_MissingIds]
      ,[MissingId]
      ,[Status]
      ,[Insert_Datetime]
      ,[Total_MissingIds]
      ,[TotalMissingIds_Success_Status]
      ,[Missed_On_Date]
  FROM [MLPreprocessing].[MM].[Missing_Run_IDs]

  Last_ExistingId	Next_ExistingId	Num_MissingIds	MissingId	Status	Insert_Datetime	Total_MissingIds	TotalMissingIds_Success_Status	Missed_On_Date
70959	70963	3	70960	 Failure	2025-04-29 15:27:27.220	279	7	2025-03-15
70959	70963	3	70961	 Failure	2025-04-29 15:27:27.220	279	7	2025-03-15
70959	70963	3	70962	 Failure	2025-04-29 15:27:27.220	279	7	2025-03-15