Help with running a task in Enterprise Manager for MS SQL 6.5

[BennyKearns]

Hello,<br><br>I am having trouble when trying to run a scheduled task form the Enterprise Manager in MS SQL 6.5 on our NT server.<br><br><br>The task is of type CmdExec and the command being executed is as follows:<br><br>cmd&nbsp;&nbsp;e:\dtnt\inviewbcp\bcpreplin.bat<br><br>The .bat file is coded as follows:<br><br>/* Tables:<br>/* stcsor01<br>/* stcsor02<br>/* stcsor03<br>/* stcsor04<br>/* stcsmf10<br>/* stcsmf11<br>/*<br>/*<br><br>/* These .exe's contain pkunzip and data.&nbsp;&nbsp;When executed, pkunzip creates the .txt files used in the bulk copy section below.<br><br>stcsor01<br>stcsor02<br>stcsor03<br>stcsor04<br>stcsmf10<br>stcsmf11<br><br>/ * Bulk copy in tables<br><br>bcp inview..stcsor01 in stcsor01.txt /n /S tdusgr_srv03 /U&lt;userid&gt; /P&lt;password&gt;<br>bcp inview..stcsor02 in stcsor02.txt /n /S tdusgr_srv03 /U&lt;userid&gt; /P&lt;password&gt;<br>bcp inview..stcsor03 in stcsor03.txt /n /S tdusgr_srv03 /U&lt;userid&gt; /P&lt;password&gt;<br>bcp inview..stcsor04 in stcsor04.txt /n /S tdusgr_srv03 /U&lt;userid&gt; /P&lt;password&gt;<br>bcp inview..stcsmf10 in stcsmf10.txt /n /S tdusgr_srv03 /U&lt;userid&gt; /P&lt;password&gt;<br>bcp inview..stcsmf11 in stcsmf11.txt /n /S tdusgr_srv03 /U&lt;userid&gt; /P&lt;password&gt;<br><br><br><br><br>Note:&nbsp;&nbsp;When I run the task, the job appears to become active.&nbsp;&nbsp;However, nothing happens (i.e. the exe's are not run).&nbsp;&nbsp;Having seen this I tried an experriment.&nbsp;&nbsp;I changed the the name of the .bat file from bcpreplin to bcprepxxx (bcprepxxx does not exist) and executed the ask again and it still appears active, even when the command is setup to run a .bat which does not exeist.<br><br><br>Any help is greatly appreciated.<br><br><br>Benny<br><br>