Solved

I need help creating a job in SQL Server 2012

Posted on 2013-12-17
3
723 Views
Last Modified: 2016-02-10
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
Comment
Question by:mainrotor
3 Comments
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39725834
Hi,
which edition of SQL Server 2012?
Where are your packages stored? File system or SSIS catalog?

Thanks.
Rainer
0
 
LVL 10

Accepted Solution

by:
sqlservr earned 500 total points
ID: 39726048
0
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 39726611
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now