-- ******************************************************************************************
    -- Create the local temp tables used in this proc
    CREATE TABLE #DRT_Update (
	    DataRetrievalTaskID		INT)
    -- ******************************************************************************************

    -- ******************************************************************************************
    -- Clear the temp table ...
ProcessNextServer:
    DELETE #DRT_Update
    -- ******************************************************************************************

    -- ******************************************************************************************
    -- Get the next Data Retrieval Task to be processed - set the status to 2 for the record selected.
    UPDATE DataRetrievalTask
	    SET [Status] = 2
	    OUTPUT inserted.DataRetrievalTaskID
		    INTO #DRT_Update
	    WHERE DataRetrievalTaskID = (SELECT MIN(DataRetrievalTaskID)
                                         FROM DataRetrievalTask
                                         WHERE [Status] = 1
                                          AND  StartTime <= GETDATE() )
    -- ******************************************************************************************