In SQL SERVER 2005, SSIS Export Job is scheduled once but running twice
Hi, I have created SSIS export package which exports the data from sql server database daily. The export package is scheduled to run once daily but from last week it is running twice for some days and exporting 0 records. I checked the schedule and it is fine (scheduled to run once daily). Why the package is running twice for some days? Please Help. Thanks, Sachin
Is it possible that your server time is drifting and that the server is having it's time synced? For example if the job is scheduled to run at 3am, and also a time sync happens at 3:01am, which puts the system clock back to 3am - then you could have 2 '3am's??