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 |
|
ruan4u
Posting Yak Master
132 Posts |
 Posted - 2004-10-01 : 09:57:50
|
| i have created DTS packages for VB.Now i have to programatically schedule it up through VB.How can this be achieved?i have a VB screen which ahs the same exact scheduling inputs.Based on these inputs i will setup with package scheduling properties.pls help!!! |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-10-01 : 11:03:12
|
| Use VB to execute a stored procedure. The stored procedure should add or alter a job to run the process on a scheduled basis.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-10-01 : 11:15:00
|
| Yes but how to schedule a job for a Package through VB or through an SP? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-10-01 : 13:19:14
|
| You can use sp_add_job and sp_update_job. They can both be found in Books Online with a good example.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-10-01 : 13:33:41
|
| Yes i had gone, through, but none tells me, how to set up job and job schedule for DTS package. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-01 : 13:35:56
|
| You have to run those stored procedures in order to setup a job and schedule it. You run those stored procedures from your VB application. Why do you want to do this through VB rather than through EM or QA?Tara |
|
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-10-03 : 12:16:40
|
| Functionality : There are 10 accounts each handled by a user.Each user wants check printed for a week report emailed at a scheduled period.Technicality :I dont think VB allows scheduling.So i thought of saving this as a Dts package.I am able to save it as a Dts package,but cant invoke the schedular for the user to define their own setting. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-04 : 12:30:54
|
| It seems to me that you should write a small service based app to do this for you. The service would poll a table every so often to see if it needed to do anything. The service would be located on some application server.Tara |
|
|
|
|
|
|
DTS package scheduling from VB