|
Home > Archive > MS SQL Server DTS > September 2005 > Can I run a Script at scheduled time?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Can I run a Script at scheduled time?
|
|
|
| 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.
| |
| Allan Mitchell 2005-09-20, 8:23 pm |
| You could use a 3rd party scheduler, windows scheduler or SQL Server
Agent to do your scheduling
Allan
"k_s" <ks@discussions.microsoft.com> wrote in message
news:1DF85386-8F97-48F1-90E9- 2705218A2247@microso
ft.com:
> 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
|
|
|
|
|