Scheduling a SSIS package

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Scheduling a SSIS package

Scheduling a SSIS package

Rate Topic

Display Mode

Topic Options

Author

Message

satish.banda

Posted Wednesday, April 16, 2008 12:10 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 04, 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

Michael Earl-395764

Posted Wednesday, April 16, 2008 6:13 AM

SSCrazy

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

satish.banda

Posted Wednesday, April 16, 2008 6:31 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 04, 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

stevefromOZ

Posted Wednesday, April 16, 2008 8:23 AM

SSCommitted

Group: Moderators
Last Login: Today @ 2:35 PM
Points: 1,763, Visits: 3,188

Check the job log (assuming it's actually erroring), also check to ensure SQL Agent is actually running.

Steve.

Post #485691

Sam-638661

Posted Thursday, April 17, 2008 2:44 AM

SSC 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

satish.banda

Posted Wednesday, April 30, 2008 4:47 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 04, 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

pduplessis-723389

Posted Monday, May 26, 2008 5:41 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, November 03, 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

Jason Coleman

Posted Monday, May 26, 2008 7:27 AM

SSC 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 »

Permissions