use MyBase

declare @NameRegZad varchar(100);

select top 10 name --, *
into #AllNameRegZad 
from sys.tables
where name like '_ScheduledJobs%';

Declare partitions CURSOR FOR Select * from #AllNameRegZad;

OPEN partitions;

while 1=1
	begin;
		fetch next
		from partitions
		into @NameRegZad
		
		If @@FETCH_STATUS < 0 BREAK;
		
		print N'zadanie name = ' + @NameRegZad;
		
		EXECUTE IMMEDIATE 'UPDATE ' + @NameRegZad +' SET use=0 WHERE use=1';
		 
	end;

close partitions;
deallocate partitions;

drop table #AllNameRegZad;
go