Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Scheduling a SSIS package Expand / Collapse
Author
Message
Posted Wednesday, April 16, 2008 12:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 4, 2009 3:35 PM
Points: 25, Visits: 161
Hi All,

How we schedule a SSIS package in SQL Server Agent JOb

can anybody tell the process

thanks
sathish
Post #485426
Posted Wednesday, April 16, 2008 6:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, Visits: 23,078
- Create a job
- Add a step
- Choose the step type for executing an SSIS package
- Select the package you want to run

The UI is fairly intuitive, you may want to just try it.
Post #485584
Posted Wednesday, April 16, 2008 6:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 4, 2009 3:35 PM
Points: 25, Visits: 161
Thanks Michael,

yesterday i have tryied in the same way how you told, job is created successfully, but it is not executing at the specified time.

what is the problem?

thanks
sathish
Post #485602
Posted Wednesday, April 16, 2008 8:23 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Today @ 8:56 AM
Points: 1,815, Visits: 3,455
Check the job log (assuming it's actually erroring), also check to ensure SQL Agent is actually running.



Steve.
Post #485691
Posted Thursday, April 17, 2008 2:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 13, 2008 6:32 AM
Points: 35, Visits: 120
You need to create a schedule from the schedule tab for the job to execute at the specified time.

Make sure you check the Enabled checkbox in the schedule tab.

Regards,
Samata
Post #486211
Posted Wednesday, April 30, 2008 4:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 4, 2009 3:35 PM
Points: 25, Visits: 161
Thanks samata,

The Enabled checkbox is checked, the job execution is failed.

The message in View History is like

Message
The job failed. The Job was invoked by Schedule 17 (NewJob1). The last step to run was step 1 (Step1).

so where iam doing mistake actually.

pls give me any suggestions

Thanks
sathish
Post #492800
Posted Monday, May 26, 2008 5:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, November 3, 2010 2:32 AM
Points: 1,249, Visits: 400
Hey Satish,

On the job history, click on the expand (+) button, and look at the history for the specific step.
Looking at the history for the job isnt going to give you much, the actual reason for failure is more likely to reside at a step level.

The first thing I would ask is if my SQL server agent has the correct access required by the package.

~PD
Post #506459
Posted Monday, May 26, 2008 7:27 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, December 12, 2011 2:47 AM
Points: 91, Visits: 183
In your SSIS package you can also create a log.
Use this log to document all the steps that your package runs through, and check the log verifies everything correctly by running the package manually through BIDS.
The next step (instead of a scheduled run) is to force the job to run through sql agent by starting it manually. Check the log for more details if the job fails, as this will give you more insight into exactly what the failure is. If the job does fail here, it's often down to security settings which haven't been configured correctly.
Post #506476
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse