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 - 2003-06-03 : 08:29:42
|
| ganapathi writes "i have a vb dll which fetches data from sybase and ports to sql server. i need the VB.dll to be run every fifteen minutes.how do i automate. I have used SP_OACreate and other ole automation objects in store proceudres to do the same, but when i call the same procedure from jobs scheduler, the jobs is not running giving error xpstar.dll error.How do i resilove that probelmsThanks a lot for suggestions." |
|
|
wilso_s
Starting Member
10 Posts |
Posted - 2003-06-03 : 14:35:26
|
| Try creating a batch file which use osql to call the sp. Then schedule the batch file to run within Windows scheduler |
 |
|
|
|
|
|
scheduling OLE Autmation objects