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
Technology Tips and News
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
Hi Zak,
Please follow the steps mentioned in below link
https://www.mssqltips.com/sqlservertutorial/220/scheduling-ssis-packages-with-sql-server-agent/
You mean the job does not run or it throws an error?but when I schedule job it dosent run.
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
Do you have any other scheduled job on the server, which runs automatically based on the scheduled time?
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