x

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

more ▼

asked Jun 06, 2011 at 03:52 AM in Default

avatar image

Sachin09
11 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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??

more ▼

answered Jun 06, 2011 at 03:56 AM

avatar image

Kev Riley ♦♦
64k 48 61 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1148
x99
x15

asked: Jun 06, 2011 at 03:52 AM

Seen: 1912 times

Last Updated: Jun 06, 2011 at 03:52 AM

Copyright 2016 Redgate Software. Privacy Policy