SSIS Job Schedule

Hi

I have scheduled SSIS package through Sql Agent and when I right click on job start job as step package runs successfully

but when I schedule job it dosent run.

Please let me know.

Thanks

August 31st, 2015 11:07am

Hi Zak,

Please follow the steps mentioned in below link

https://www.mssqltips.com/sqlservertutorial/220/scheduling-ssis-packages-with-sql-server-agent/

Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 11:12am

I tried Proxy account but it doesn't work that way either.
August 31st, 2015 11:36am

but when I schedule job it dosent run.

You mean the job does not run or it throws an error? 
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 11:48am

It doesn't throw an error. I checked history but its not showing any error.

but when I right click and run it it works properly and it is showing in history as well

August 31st, 2015 11:53am

Check your Job Schedule Properties and see if Enabled is checked.
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 12:15pm

It is enabled
August 31st, 2015 12:24pm

Is "No end date" is checked?
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 12:25pm

Yes It does
August 31st, 2015 12:27pm

Is Job Enabled?
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 12:31pm

Yes It  is enabled
August 31st, 2015 12:45pm

Do you have any other scheduled job on the server, which runs automatically based on the scheduled time?

Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 2:31pm

Hi zak_kapoor,

According to your description, the job runs successfully when manual execute the job via right click on job with Start Job as Step option. While it doesnt run via a schedule.

As per my understanding, the issue should be related to the schedule for the job. Please make sure the date is between Start date and End date, it doesnt have an expired duration. Then make sure the time you check history is later than the frequency.

If the issue is still existed, please post a screenshot about your job schedule for us reference.

Thanks,
Katherine Xiong

September 1st, 2015 3:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics