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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 does SSIS has a built-in scheduler?

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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.
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -