pskeens
asked on
SSIS scheduled job runs but nothing happens unless manually executed
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.