Create Procedure [dbo].[CicloSendOCR_{0}]
		as
		DECLARE @Contador INT , @MaxId INT, @Pid int, @unid int, @uid int
		SELECT @Contador = 1

		Select packageid,userid,unitid,ROW_NUMBER() OVER(ORDER BY packageid ASC) AS ID into #Temporal from sys_Packages where cast(date as date)=cast(getdate() as date) and notified=-1
		
		SELECT @MaxId = Count(packageid) from #Temporal
	
		print @Contador
		print @MaxId


		BEGIN TRY  
				WHILE(@Contador IS NOT NULL AND @Contador <= @MaxId)
				BEGIN
				   SELECT @Pid = A.packageid, @unid=A.unitid, @uid=A.userid
				   from #Temporal as A  
				   WHERE ID = @Contador
    
				   SET @Contador  = @Contador  + 1  
				   print @Contador
				   exec dbo.sendNotifOCR_{0} @Pid, @uid, @unid 
				   --WAITFOR DELAY '00:00:08';
				END
		END TRY  
		BEGIN CATCH  
			SELECT   
				ERROR_NUMBER() AS ErrorNumber  
			   ,ERROR_MESSAGE() AS ErrorMessage;  
		END CATCH  

		Drop Table #Temporal