Thanks for this. Looks like something that I could use. A few minor errors, I think many of them are due to website converting from " (double quotes) to '' (two single quotes)
I managed to correct most of these, but got a little stuck at the last script just before step4
the first problem I found was
EXEC @ReturnCode = msdb.dbo.sp_add_job
@job_name=”Whats Running Now',
(Note the quote mark before Whats)
After changing that I had several more coding issues and had to put it on hold as I had to get back to work but I will be keen to get this working and continue with step 4 and beyond.