Solved

I need help creating a job in SQL Server 2012

Posted on 2013-12-17
3
734 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Database Integrity 1 49
SQL Log size 3 17
MS SQL Server select from Sub Table 14 23
query linked sql table field from access 4 20
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

856 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