available free space in a job step command 1

[shanghai2004]

Dear Expert,

I try to create a job for a query. I got an error message:

The specified file is 4181 characters in size,which is larger than the available free space in the current job Step command(3200 characters).
Do you want to continue opening this file but have its contents truncated.

Is there a way to increase the free space in job Step command?

Thanks

 

[vongrunt]

Make code shorter

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[SQLDenis]

split it up in 2 steps

or make a stored procedure and call the stored procedure from the step

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/