This anwer works for the given data but wouldn't work if we inserted a row like:

insert into #new(id,keyvalue) values (1,'bb')

The stated answer assumes a duplicate is defined by the ID...

per the comments in the msdb.dbo.sp_get_composite_job_info sp the state values are defined as follows:

0 = Not idle or suspended,

1 = Executing,

2 = Waiting For Thread,

3 = Between...