Friday, March 9, 2012

Maximum job size limited to 3200 bytes

Hi all. I have sql server 2000, and am trying to do a job
(administration/sql server agent/jobs) with sql server enterprise
manager, but the job exceeds 3200 bytes and it tells me that it will
truncate the program.
Is there a way to increase the maximum job size?That is the limit on the script size. One workaround is to create a
procedure & execute this procedure within the job.
Anith

No comments:

Post a Comment