Run Script from drive location

Hi,
How can I run a script in a job and call it from a drive location?
ie. the script file will be located on a network share.
The script is more than 3200 chars so I cannot call it in the job step.
Thanks.use OSQL. You can specify your script using the -i option of OSQL.
"Jaco" wrote:

> Hi,
> How can I run a script in a job and call it from a drive location?
> ie. the script file will be located on a network share.
> The script is more than 3200 chars so I cannot call it in the job step.
> Thanks.|||Hi Jaco,
Use a CmdExec job step and run the script file in the step like this
osql -i c:\Myscript.sql
Hope this helps|||Thanks guys, sorted.
"Omnibuzz" wrote:

> Hi Jaco,
> Use a CmdExec job step and run the script file in the step like this
> osql -i c:\Myscript.sql
>
> Hope this helps