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 |
|
kwilliams
194 Posts |
 Posted - 2004-02-24 : 10:02:42
|
| Hello,I'm really hoping that someone can help me out with this one. I have a SQL job that exports data from an internal server (DB1) to an external web-server (DB2). I was told that it's also possible to add a batch job that would actually copy an actual directory subfolder from the DB1 to DB2 in SQL Server itself. He told me that I could add this job before the current export job so that it's all scheduled correctly.Is this possible to do this in SQL Server? If so, do you know how to do it? If not, could you point me in the right direction? Thanks for any and all help.P.S. If there's a better way of accomplishing this task, any other suggestions are also appreciated. Thanks.KWilliams |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-02-24 : 10:07:41
|
| I think you're after the xp_cmdshell option. This basically lets you shell out to a DOS session, where you could do the folder copy you are talking about. Be aware that the job should be run using a domain account that has access to both servers and their folders.Raymond |
 |
|
|
kwilliams
194 Posts |
Posted - 2004-02-24 : 10:10:53
|
| Thanks Raymond,I'll check into this option, and I'll add another post if I'm successful.KWilliams |
|
|
|
|
|
|
NEWBIE: Batch Job Question