Hi all,
I have to run a DTS on a remote server, which copies data from one DB to
another on same server.
The problem is, the connection is poor and I've not been able to save the
DTS on that server. There is no tech guy who can do the work of saving DTS ,
for me.
I have created a script, which do the same work for me as the DTS, and run
it manually everyday on remote server using Query analyzer.
Ok, I can create a cmd and batch file of the script and run it, but how to
run it as a job so that I can schedule it?
thanks

If you already have a script to run it with cmd in DOS mode (I assume
via OSQL), what about using the at command to schedule the job to run
at specific times ?
Another option, if you want to do it with SQL Server is to Execute the
script time scheduled with the SQL Agent.

HTH, Jens Suessmeyer.

You could use a 3rd party scheduler, windows scheduler or SQL Server
Agent to do your scheduling

Allan

"k_s" <ks (AT) discussions (DOT) microsoft.com> wrote