Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 752
  • Last Modified:

I need help creating a job in SQL Server 2012

How can I create a job that will execute an SSIS package without creating a schedule for it in SQL server 2012?

Thanks in advance,
mrotor
0
mainrotor
Asked:
mainrotor
1 Solution
 
Rainer JeschorCommented:
Hi,
which edition of SQL Server 2012?
Where are your packages stored? File system or SSIS catalog?

Thanks.
Rainer
0
 
Ryan McCauleyCommented:
Are you asking specifically how to create a job that's unscheduled, or do you need help actually creating a job? When you create a SQL Agent job, it's not necessary to create or assign a schedule - in that case, you'd just run the job on demand, rather than on a given schedule.

If you need help actually running the SSIS package, the other link posted will help you do that.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now