I have two very similar jobs on a SQL2008r2 instance. Each one selects data from one of two structurally identical tables and exports it to one of two SQLAzure databases with the same schema every fifteen seconds. The work is done in SSIS. For several months, this ran smoothly.
Yesterday at 1:19 AM (i.e. 1:19 on March 24), BOTH jobs apparently began to run and just never stopped. Even though both jobs were running, their respective SSIS packages were NOT.
What could cause this sort of behavior and how can I prevent it from happening again?
Thanks for reading.