October 14, 2009 at 2:42 pm
I need to create a job that runs nightly that simply executes a SSIS package. Is there a way to create and schedule the job without using SQL Server Agent (my current set up does not allow me to access the SQL Server Agent in SSMS)?
If so, if anyone could point me to an online resource with detailed instructions, or if you could provide your own solution, I would really appreciate it.
October 14, 2009 at 2:55 pm
I think this link covers your needs quite well. Windows Scheduler can start your job this way.
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 14, 2009 at 2:56 pm
r.hensbergen (10/14/2009)
I think this link covers your needs quite well. Windows Scheduler can start your job this way.
Err, and then I forgot to paste the link... http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 14, 2009 at 3:03 pm
What is the problem with Agent? You certainly can use Windows Scheduler but I would only as a last resort. Agent is designed to hande this..
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply