Solved

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

Posted on 2013-12-18
2
483 Views
Last Modified: 2013-12-18
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.
0
Comment
Question by:cindyfiller
2 Comments
 
LVL 10

Accepted Solution

by:
PadawanDBA earned 500 total points
ID: 39726800
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
 

Author Comment

by:cindyfiller
ID: 39727104
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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question