Increase TEXT SIZE in SQL Server Agent

2.4k views Asked by At

SQL Server Agent has a 512 characters limit on texts fields like nvarchar(max). I found this out after seeing my stored procedure is working correctly when I run it in SSMS but not working when is being run by a SQL Server job.

To fix this I know I can use SET TEXTSIZE { number } in my stored procedure to increase this number. However I don't want to add this line in each and every stored procedure that are being run by SQL Server jobs. Is there a way that I can set this value for SQL Server agent itself?

1

There are 1 answers

0
rmulkey On

Hear my plea MS. Be kind to our eyes and allow us to increase the SQL Agent font size.

I use a sysinternals tool called ZoomIt. Pressing [Control] + [1] takes a snapshot of the screen and zooms in to various magnifications. It's a far cry from increasing the Agent job & steps, but works in a pinch.

Another work around is to return the job or it's steps in a query window.

select subsystem, step_id, step_name, command from sysjobsteps where job_id in 
(select job_id from sysjobs where name like '%Some Job with tiny screen letters%')