ETL package fails when run as a schedule job - works fine if run manually

I have a scheduled ETL package that has run for many years every night without an issue.  Suddenly it has started to fail every night.  I can still run it manually and it completes successfully.  I thought maybe the job was corrupt so recreated it but that new job also fails.  I am not finding any details on the job history - just the history that it fails on step 1 (and there is only 1 step that is very long).  This package rebuilds our data warehouse.  I'm not sure how to troubleshoot this.
cindyfillerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
PadawanDBAConnect With a Mentor Operational DBACommented:
Are there any errors in the windows and/or sql server event log(s) that correspond to the time of execution on the automated run?
0
 
cindyfillerAuthor Commented:
I didn't realize that it logged each portion of the ETL package out in the event viewer.  I see what module is failing - which I didn't know before.  That helps tremendously.  Now I can focus on that.
0
All Courses

From novice to tech pro — start learning today.