We have a code to collect all jobs & Job step details from different servers under our support. I'm using the system proc sp_help_job to collect job details which is calling internally the sp_help_jobstep proc. On one of our server I'm getting this below error when the proc executed.
Msg 8152, Level 16, State 10, Procedure sp_help_jobstep, Line 95
String or binary data would be truncated.
Anybody experienced this issue any workaround?
Thanks in advance...
Warmest
Jay.