dbTalk Databases Forums  

scheduling package

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


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



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

Default scheduling package - 04-19-2005 , 12:48 PM






Hi all gurus

If I create a package and schedule it for jobs and then if i delete the
package and create a new package with same name. Then my job for old package
will run on new package with name of old deleted package?

will it make any problem?

Thanks
AM



Reply With Quote
  #2  
Old   
Denis
 
Posts: n/a

Default Re: scheduling package - 04-19-2005 , 01:34 PM






No it will not run the new package
If you look in the step of the job you will see a DTS run command
something like DTSRun /~Z0xB7A73C..........
if you delete and create a new package this number after DTSRun will change
try scheduling the new package and you will see the number has changed





"AM" <anonymous (AT) developersdex (DOT) com> wrote

Quote:
Hi all gurus

If I create a package and schedule it for jobs and then if i delete the
package and create a new package with same name. Then my job for old
package
will run on new package with name of old deleted package?

will it make any problem?

Thanks
AM





Reply With Quote
  #3  
Old   
AM
 
Posts: n/a

Default Re: scheduling package - 04-19-2005 , 01:54 PM



hi

But in my case i can run the new package with old name from old job

How this happened?

AM

"Denis" <denis.gobo (AT) gmail (DOT) com> wrote

Quote:
No it will not run the new package
If you look in the step of the job you will see a DTS run command
something like DTSRun /~Z0xB7A73C..........
if you delete and create a new package this number after DTSRun will
change
try scheduling the new package and you will see the number has changed





"AM" <anonymous (AT) developersdex (DOT) com> wrote in message
news:O00pwdQRFHA.3144 (AT) tk2msftngp13 (DOT) phx.gbl...
Hi all gurus

If I create a package and schedule it for jobs and then if i delete the
package and create a new package with same name. Then my job for old
package
will run on new package with name of old deleted package?

will it make any problem?

Thanks
AM







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.