Re: How To Setup a Batch Job To Run Daily

Thanks very much, Allan.

"Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx> wrote in message
news:f0343b0312be38c7f52506506ea0@xxxxxxxxxxxxxxxxxxxxxxx
Hello Diane,

Ok I think the terminology might be confusing here.

You can use a cmdline command in a batch file that calls
DTSRun - if you need to call a package to move the rows
bcp - if you want to move the rows to text file with no DTS package.

If you use SQL Server Agent then there is a job step that effectively gets
the cmdline for you (Operating System (CmdExec))
Most other schedulers will do that as well including Windows Scheduler.


DTSRun is a command line interface to call a DTS Package. The syntax is
straight forward.

http://www.sqldts.com/default.aspx?301


Allan




Hello Allan,

Thank you very much for your information and prompt response. I
assume that I need to use DTSRun command to setup a batch file. Then
use DTS package to schedule the job that I setup in DTSRun. Anyway,
is there another way to setup a batch job to export records besides
using DTS? Thanks.

"Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx> wrote in message
news:f0343b0312a4c8c7f4a5aa6b7970@xxxxxxxxxxxxxxxxxxxxxxx

Hello Diane,

You can use Windows Scheduler, SQL Server Agent or any of the 3rd
party offerings like AutoSys. You simply call the batch file.

Where does DTS come into this? Are you using DTS to do the export?
if you are then you may want to look at the syntax for DTSRun in
Books-Online

Allan

Thanks very much for your information and prompt response. Is there
another way to schedule a batch file? Thanks.

"Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx> wrote in message
news:f0343b03125608c7f4061bb75ed0@xxxxxxxxxxxxxxxxxxxxxxx

Hello Diane,

Do you mean how do you schedule a DTS package the exports rows to a
text file?

SQL Server Agent or your favourite scheduler will do the scheduling
but here is some syntax help and nuances.

http://www.sqldts.com/redir.aspx?269074

http://www.sqldts.com/default.aspx?301

Allan

We are running SQL 2000 Enterprise Server Edition under Windows
2003 Server Standard Edition. How do you schedule a batch file to
run daily to export selected records?

Thanks.





.

Relevant Pages

  • Problem backing up Analysis Services db using Microsoft Article 312399
    ... msmdarch.exe and if I run the DTS package manually it works fine. ... however when I try to schedule the job. ... a domain account that has rights to execute the bat file and also has rights ... DTSRun: Loading... ...
    (microsoft.public.sqlserver.olap)
  • Re: How To Setup a Batch Job To Run Daily
    ... If you use SQL Server Agent then there is a job step that effectively gets the cmdline for you ) ... DTSRun is a command line interface to call a DTS Package. ... use DTS package to schedule the job that I setup in DTSRun. ... You simply call the batch file. ...
    (microsoft.public.sqlserver.dts)
  • Re: Schedule a DTS Package with a Password
    ... What part of the DTS package requires a password? ... Is this "In" the package or is this in order to execute the package ie a user password? ... To run on a schedule I would use SQL Server Agent and DTSRun. ...
    (microsoft.public.sqlserver.dts)
  • Re: Schedule Batch File-How to?
    ... Panel> Scheduled Task etc. and the batch file name was used as the program ... The destination locations were checked to insure execution had taken place ... Windows command that you are using within the batch file. ... according to the schedule you selected. ...
    (microsoft.public.windowsxp.general)
  • Re: Scheduled task "run as" question
    ... I suggested that you should schedule a two-line batch file, ... - You also report "Although the script never runs". ... specific understanding in troubleshooting Scheduled Tasks (they normally ...
    (microsoft.public.windows.server.general)