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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2012-12-03 : 11:17:27
|
| Hi, everyone,I am just wondering if ssis in sql 2008 r2 has a built-in scheduler which will let me run my package in off peak hour. In the development stage, I don't want to add jobs into sql server for ease of management reason if I don't have to.I know the options of build/deploy to sql server and use the agent, or use other scheduler to run the package from cmd line/power script etc. Thanks! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-03 : 11:22:28
|
| Nope..The built in scheduler for sql server is SQL Server Agent which is what is used for running SSIS packages as well.If you want to schedule packages you need sql server job but that doesnt mean you need to deploy packages to server.You can put packages in a shared folder itself as .dtsx file and configure jobs to pick them and execute from file system rather than from sql server Integration services------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2012-12-03 : 11:48:04
|
| ah, thank you!That could be something to be on my wishing list...So ssis has exec sql server agent job task but no create new agent job capability. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-03 : 12:16:01
|
| nope. job has to be created from sql agent GUI or by using sp_create_job system procedure------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
does SSIS has a built-in scheduler?