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 |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2002-07-03 : 03:05:52
|
| hi,we have scheduled an exe in sql server.the exe reads the connection string from a text file , connects to a website and gets an xml file from there analyses the xml and stores the records in the table in sql server.are there any other options available to do this task .and is calling an .dll prefered over calling an .exe from a job?thnxs,Harsh. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-07-03 : 08:26:55
|
| Sounds like you have a good approach to this.An exe will be stand alone so is easier to test and be more remote from the server so should have less impact than a dll.You might want to use sql server to interpret the xml - but having a stand alone exe for the job gives encapsulation so is probably easier to maintain and more flexible.Just make sure you have designed and tested it for failures / reprocessing / failing to run for a long time.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-07-04 : 00:24:26
|
| thnxs,harshal. |
|
|
|
|
|
|
calling exe from a job