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
mainrotorAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rainer JeschorCommented:
Hi,
which edition of SQL Server 2012?
Where are your packages stored? File system or SSIS catalog?

Thanks.
Rainer
0
 
Ryan McCauleyData and Analytics ManagerCommented:
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
All Courses

From novice to tech pro — start learning today.