Solved

SSIS scheduled job runs but nothing happens unless manually executed

Posted on 2012-03-17
1
976 Views
Last Modified: 2012-03-17
I have an SSIS job schedled to run every hour.  The job runs perfectly without errors when manually executing it.  On the schedule it shows as executed without errors however there is nothing that happens.  None of the data has changed.  Looking through the history I can see wehre every time it ran it says successfully completed.

Date            3/17/2012 12:50:00 AM
Log            Job History (TransferDataFeed)

Step ID            0
Server            MyCOMPUTERNAME-VAIO
Job Name            TransferDataFeed
Step Name            (Job outcome)
Duration            00:00:01
Sql Severity            0
Sql Message ID            0
Operator Emailed            
Operator Net sent            
Operator Paged            
Retries Attempted            0

Message
The job succeeded.  The Job was invoked by Schedule 9 (DailyRoutine).  The last step to run was step 1 (ExecutePackage).


This is running on SQL Server 2008R2 and the job is scheduled through Agent in Microsoft Studio 2008r2 Complete.
0
Comment
Question by:pskeens
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
pskeens earned 0 total points
ID: 37733090
Solved!  I created server credentials for myself and then created a proxy for these credentials.  Then on the "Run As" in the job configuration selected the proxy user.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

627 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