mainrotor
asked on
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
Thanks in advance,
mrotor
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
If you need help actually running the SSIS package, the other link posted will help you do that.
which edition of SQL Server 2012?
Where are your packages stored? File system or SSIS catalog?
Thanks.
Rainer