Code fails in case-sensitive environment

[ylavi]

RestoreCommand.sql doesn't run as is in case-sensitive environments.

The following needs to be changed (in two places)

 FETCH NEXT FROM restorecursor
 INTO @databasename, @command

to

 FETCH NEXT FROM RestoreCursor
 INTO @DatabaseName, @Command

and all other references to restorecursor need to be changed to RestoreCursor

[ylavi]

Also the job step creation script needs similar adjustments.

For consistency with the other variables I suggest changing all cases of @jobid and @jobID to @JobId

The following changes are also required:
Msdb.dbo.SysJobs -> msdb.dbo.sysjobs
Msdb.dbo.SysJobSteps -> msdb.dbo.sysjobsteps
Job_Id -> job_id
jobidcursor -> jobidCursor