SSIS Package Scheduled through SQL_Agent stops running

  • I have an SSIS package running on SQL Server 2005 that was imported from VS 2005.  It is scheduled through SQL agent and executes twice a day.  After about a week of running,  it will just stop.  I don't see anything in the history log (successes or failures) that the job was even started.  I can manually execute the pakage,  but am puzzled about the schedule.  I waited over 24 hours to see if it catches up but it doesn't.  I'm not even sure how look and see of the job ever started.  Has anyone run into anything like this?

  • Do you have the package source (.dtsx or in msdb)? If so, could you turn on logging for the package in order to see what's going on? What does the job history show?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply