SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 does SSIS has a built-in scheduler?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Hommer
Aged Yak Warrior

786 Posts

Posted - 12/03/2012 :  11:17:27  Show Profile  Reply with Quote
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

India
52323 Posts

Posted - 12/03/2012 :  11:22:28  Show Profile  Reply with Quote
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

786 Posts

Posted - 12/03/2012 :  11:48:04  Show Profile  Reply with Quote
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

India
52323 Posts

Posted - 12/03/2012 :  12:16:01  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000