Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-10 : 08:10:47
|
| ayamas writes "I have one problem.In my project I have different databases at 3 diff locations.Whatever the transactions are done are done at the local database of that particular location.What I want is I will add some windows schedule tasks which will connect to these locations through dial up in the night.As soon as it gets connected the particular job which will designed in the particular server should run & the data should be transferred from those databases to my main database on at a time.Can it be done through replication?If yes then how?Or is there some other way.It is some what like POS.Any help is greatly appreciated.Thanks in advanceRegards,ayamas" |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-05-10 : 09:17:56
|
| Add a osql cmd to your windows scheduled task to run a job on the local server, this would be your best bet as it wouldn't try to run if the connection ddin't exist.. |
 |
|
|
ayamas
Aged Yak Warrior
552 Posts |
Posted - 2006-05-17 : 04:44:42
|
| but how can i make sure that osql cmd is run only when the connection is present because the windows scheduled task will run only to connect to that particular location. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-05-17 : 08:33:35
|
| Add it to the scheduled task.. |
|
|
|
|
|
|
SQL & Windows scheduled jobs