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 - 2007-01-04 : 09:50:32
|
| Phil writes "Hi,Here is my dilemma. I would like to create an SSIS package that will dynamically run different scripts/reports for my company. I would like to use one SSIS package and then dynamically create the jobs based on the schedule of when these scripts should run. For instance, if I have two scripts that create excel documents that run at 2:00 P.M daily I would like to use the job agent and have both of these scripts start at 2:00 PM. Instead of having one run and then the other has to wait until it's complete. First of all, is this even possible? Second has anybody ever played around with this and if so can you give me some guidance?Thanks,Phil" |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-04 : 11:13:37
|
| You don't need to create one package, just create jobs for each of the scripts and schedule them. If they are scheduled to run at the same time, they'll run at the same time. |
 |
|
|
tacket
Starting Member
47 Posts |
Posted - 2007-01-08 : 10:53:55
|
| Hi,Is there a way to tie the schedule into a custom database I'm building? My end goal, would be to have a database with scripts/schedules and be able to insert a record with a script and have that automatically tie back into the job agent to create a job automatically using this package. Just wondering if anybody has played with that before. Thanks,Phil |
|
|
|
|
|
|
SSIS & job agent