dbTalk Databases Forums  

scheduling problem

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss scheduling problem in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kieran
 
Posts: n/a

Default scheduling problem - 05-22-2006 , 05:21 AM






Hi,

I have a dts package that is scheduled to run at 9am and have the dts log
files that show it running at that time.

When i right click on the package and click on 'schedule package' and then
input a different time, the package does not seem to run at this time -
nothing appears in the log files.

However the package still executes at 9am and the log files show this.

How can i set up this package to run at a different time or a new package to
run at a different time

Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: scheduling problem - 05-22-2006 , 02:31 PM






You can view and control that easier through the job itself.
When you do a right click, schedule on a package, it creates
the job for you. The job is typically the same name as the
package. You can go and edit the schedule for that job.

-Sue

On Mon, 22 May 2006 03:21:01 -0700, Kieran
<Kieran (AT) discussions (DOT) microsoft.com> wrote:

Quote:
Hi,

I have a dts package that is scheduled to run at 9am and have the dts log
files that show it running at that time.

When i right click on the package and click on 'schedule package' and then
input a different time, the package does not seem to run at this time -
nothing appears in the log files.

However the package still executes at 9am and the log files show this.

How can i set up this package to run at a different time or a new package to
run at a different time


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.