declare @jobid int
set @jobid = 2
declare @status int
set @status = 1
insert into joblog
	(jobid, email, joblogstatusid)
select @jobid, email, @status
	from mailingitem where (mailinglistid=1)