Job step command box can hold only 3200 characters

I could not load a batch file into the command box of a job step because it
exceeded the 3200 character limit. How do I increase this limit?
Mucho gracias.
LaEsmeraldaUse another job step.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"LaEsmeralda" <LaEsmeralda@.discussions.microsoft.com> wrote in message
news:B53AE718-D28F-473F-B347-D547D1072A2D@.microsoft.com...
>I could not load a batch file into the command box of a job step because it
> exceeded the 3200 character limit. How do I increase this limit?
> Mucho gracias.
> LaEsmeralda

Job step command box can hold only 3200 characters

I could not load a batch file into the command box of a job step because it
exceeded the 3200 character limit. How do I increase this limit?
Mucho gracias.
LaEsmeraldaUse another job step.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"LaEsmeralda" <LaEsmeralda@.discussions.microsoft.com> wrote in message
news:B53AE718-D28F-473F-B347-D547D1072A2D@.microsoft.com...
>I could not load a batch file into the command box of a job step because it
> exceeded the 3200 character limit. How do I increase this limit?
> Mucho gracias.
> LaEsmeraldasql

Job step command box can hold only 3200 characters

I could not load a batch file into the command box of a job step because it
exceeded the 3200 character limit. How do I increase this limit?
Mucho gracias.
LaEsmeralda
Use another job step.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"LaEsmeralda" <LaEsmeralda@.discussions.microsoft.com> wrote in message
news:B53AE718-D28F-473F-B347-D547D1072A2D@.microsoft.com...
>I could not load a batch file into the command box of a job step because it
> exceeded the 3200 character limit. How do I increase this limit?
> Mucho gracias.
> LaEsmeralda

Job Sequencing ?

I have a job that runs a batch file, tsql step, and then another batch file.
My question is will the agent say the first step is complete and move on
when it starts the batch file or will it know to wait until after the batch
has ran to start the second step?
TIA
--
nivekHi
It waits for the prior step to finish.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"nivek" <eckart_612@.hotmail.com> wrote in message
news:36GdnYIXz77QzN3fRVn-3A@.centurytel.net...
> I have a job that runs a batch file, tsql step, and then another batch
file.
> My question is will the agent say the first step is complete and move on
> when it starts the batch file or will it know to wait until after the
batch
> has ran to start the second step?
> TIA
> --
> nivek
>
>
>

Job Sequencing ?

I have a job that runs a batch file, tsql step, and then another batch file.
My question is will the agent say the first step is complete and move on
when it starts the batch file or will it know to wait until after the batch
has ran to start the second step?
TIA
nivekHi
It waits for the prior step to finish.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"nivek" <eckart_612@.hotmail.com> wrote in message
news:36GdnYIXz77QzN3fRVn-3A@.centurytel.net...
> I have a job that runs a batch file, tsql step, and then another batch
file.
> My question is will the agent say the first step is complete and move on
> when it starts the batch file or will it know to wait until after the
batch
> has ran to start the second step?
> TIA
> --
> nivek
>
>
>

Job Sequencing ?

I have a job that runs a batch file, tsql step, and then another batch file.
My question is will the agent say the first step is complete and move on
when it starts the batch file or will it know to wait until after the batch
has ran to start the second step?
TIA
nivek
Hi
It waits for the prior step to finish.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"nivek" <eckart_612@.hotmail.com> wrote in message
news:36GdnYIXz77QzN3fRVn-3A@.centurytel.net...
> I have a job that runs a batch file, tsql step, and then another batch
file.
> My question is will the agent say the first step is complete and move on
> when it starts the batch file or will it know to wait until after the
batch
> has ran to start the second step?
> TIA
> --
> nivek
>
>
>
sql