use set ANSI warnings off before u write job execution step exec job name & set ansi warnings on job execution step.

it will resolve ur problem.

syntax

SET ANSI_WARNINGS OFF

GO

exec SERVICE_RESUB

go

SET...