Suspend batch jobs temporarily

You might have some scheduled jobs in your dev environment running which might slow down the performance of your system at times, to temporarily suspend it, here is the SQL:

update schactive set scsprefstart = current timestamp + 12 hours where scsjobnbr in (
select a.SCSJOBNBR from schconfig s , schactive a
where s.SCCJOBREFNUM = a.SCSJOBNBR
and a.scsstate in ('I','R')
and s.sccpathinfo in '<<JOBNAME(s)>>');