Great script but gives me an error.
Msg 102, Level 15, State 1, Line 12
Incorrect syntax near ' '.
I pasted the whole query into my Notepad++ and there I could see what the problem was:
SELECT SJ.name as job_name
, SJ.enabled as is_job_enabled
, SS.enabled as is_schedule_enabled
/*, ISNULL(SJ.description, '') as job_desc*/
, SS.name as schedule_name
, CASE freq_type
????WHEN 1 THEN 'Occurs on ' + STUFF(RIGHT(active_start_date, 4), 3,0, '/') + '/' + LEFT(active_start_date, 4) + ' at '
????????+ REPLACE( RIGHT(CONVERT(varchar(30),
So I got rid of the question marks, let SQL Refactor do the layout and it worked like a charm!
Probably a problem related to my setup but just in case somebody else has the same problem I attached the script.