Thank you everyone. This does what I need;

use MSDB

go

SELECTsysjobs.NAME,

sysjobsteps.step_name,

sysjobsteps.command,

sysschedules.name,

CASE

WHEN freq_type = 1 THEN 'Once only'

WHEN freq_type = 4 THEN 'Daily'

WHEN freq_type = 8 THEN 'Weekly'

WHEN freq_type =...

Thanks this looks exactly what I need as a strating point. If I add details from sysschedules, it should do the trick, I'll let you know how I get on.