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

Sachin09 gravatar 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

Kev Riley gravatar image

Kev Riley ♦♦
52.8k 47 49 76

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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:

x928
x86
x12

asked: Jun 06, 2011 at 03:52 AM

Seen: 1692 times

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