I tried to execute the following jo

[fogal]

I tried to execute the following job, but it failed. It kills processes older than one day, that are non system user processes.

All ideas welcome.

declare @spid int, @sql varchar(1000)
select @spid = 10
while exists (select * from master..sysprocesses where spid > @spid and login_time > dateadd(dd,-1,getdate()))
begin
select @spid = min(spid) from master..sysprocesses where spid > @spid and login_time > dateadd(dd,-1,getdate())
select @sql = 'kill ' + convert(varchar(20),@spid)
exec (@sql)
end

 

[clapag22]

Fails or just doesn't do what you think it should?

I'm thinking it should be:

login_time < dateadd(dd,-1,getdate())