|
|
You're in the
sql server dts
group:Scheduled Package dose not being instanciated more than once
sql server dts:
the Parent package to be executed evey 3 minutes and I'm using a Table in which I insert the name of the child package which is working and when it is done I delete the row,by this mechanism I control not 2 child packages get executed at the same time(Because they do transactional things on their own table, and I won;t tend to be stuck in deadlocks). Problem is that I am expecting that two different child packages could be executed at the same time but for some reason when Parent package call one child package and it takes more than 3 minutes,none of the other packages run.There is no any other instance of Parent package running. When I schadule something ,it is supposed to be run at an specific interval right? Thanks
The same job cannot be run more than once at the same time.
A way to control child package exeution would be to link them through workflow wouldn't it? -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - You thought DTS was good. here we show you the new stuff. www.konesans.com - Consultancy from the people who know [quoted text, click to view] "J-T" <J-T@nospam.com> wrote in message news:ulaKIj4cFHA.412@tk2msftngp13.phx.gbl... >I have a Parent package which call different child packages.I have >schaduled the Parent package to be executed evey 3 minutes and I'm using a >Table in which I insert the name of the child package which is working and >when it is done I delete the row,by this mechanism I control not 2 child >packages get executed at the same time(Because they do transactional things >on their own table, and I won;t tend to be stuck in deadlocks). > > Problem is that I am expecting that two different child packages could be > executed at the same time but for some reason when Parent package call one > child package and it takes more than 3 minutes,none of the other packages > run.There is no any other instance of Parent package running. > > When I schadule something ,it is supposed to be run at an specific > interval right? > > Thanks >
Hi Allan,
My parent package is a separte package than the child packages.I load the package based on the CSV file which is recieved in Parent package,then in an Activex script I load the appropriate package. [quoted text, click to view] > The same job cannot be run more than once at the same time. What a pitty,I thought it could be.Now the only option I have is that I can create two or three jobs of my Parent Package,can I? My only concern is that child packages logging the validation errors in one Table (That table is shared between all the child packages).Will I be stuck in dead lucks or something? I insert the log records by calling a stored procedure (no transaction involved) in child packages(there is a Execute SQL Task in each child package which referes to that stored procedure). Thanks for your help Allan (as always:-)) Cheers, [quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:OXTVqP$cFHA.3488@tk2msftngp13.phx.gbl... > The same job cannot be run more than once at the same time. > > A way to control child package exeution would be to link them through > workflow wouldn't it? > > > -- > > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > www.SQLDTS.com - The site for all your DTS needs. > www.SQLIS.com - You thought DTS was good. here we show you the new stuff. > www.konesans.com - Consultancy from the people who know > > > "J-T" <J-T@nospam.com> wrote in message > news:ulaKIj4cFHA.412@tk2msftngp13.phx.gbl... >>I have a Parent package which call different child packages.I have >>schaduled the Parent package to be executed evey 3 minutes and I'm using a >>Table in which I insert the name of the child package which is working and >>when it is done I delete the row,by this mechanism I control not 2 child >>packages get executed at the same time(Because they do transactional >>things on their own table, and I won;t tend to be stuck in deadlocks). >> >> Problem is that I am expecting that two different child packages could be >> executed at the same time but for some reason when Parent package call >> one child package and it takes more than 3 minutes,none of the other >> packages run.There is no any other instance of Parent package running. >> >> When I schadule something ,it is supposed to be run at an specific >> interval right? >> >> Thanks >> > >
The same package cn be called at the same time multiple times.
OK so what I think you are trying to do is this Fire a DTS package every 3 minutes (Parent) In the parent package you check a csv file. Based on the CSV file you call a package(Child) I am not sure how you do the check here. Would it be possible for you to fire the package based on an event? The file being dropped? -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - You thought DTS was good. here we show you the new stuff. www.konesans.com - Consultancy from the people who know [quoted text, click to view] "J-T" <J-T@nospam.com> wrote in message news:e5OWyMHdFHA.3616@TK2MSFTNGP09.phx.gbl... > Hi Allan, > > My parent package is a separte package than the child packages.I load the > package based on the CSV file which is recieved in Parent package,then in > an Activex script I load the appropriate package. > >> The same job cannot be run more than once at the same time. > What a pitty,I thought it could be.Now the only option I have is that I > can create two or three jobs of my Parent Package,can I? My only concern > is that child packages logging the validation errors in one Table (That > table is shared between all the child packages).Will I be stuck in dead > lucks or something? I insert the log records by calling a stored procedure > (no transaction involved) in child packages(there is a Execute SQL Task in > each child package which referes to that stored procedure). > > Thanks for your help Allan (as always:-)) > > Cheers, > > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > news:OXTVqP$cFHA.3488@tk2msftngp13.phx.gbl... >> The same job cannot be run more than once at the same time. >> >> A way to control child package exeution would be to link them through >> workflow wouldn't it? >> >> >> -- >> >> >> >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) >> www.SQLDTS.com - The site for all your DTS needs. >> www.SQLIS.com - You thought DTS was good. here we show you the new >> stuff. >> www.konesans.com - Consultancy from the people who know >> >> >> "J-T" <J-T@nospam.com> wrote in message >> news:ulaKIj4cFHA.412@tk2msftngp13.phx.gbl... >>>I have a Parent package which call different child packages.I have >>>schaduled the Parent package to be executed evey 3 minutes and I'm using >>>a Table in which I insert the name of the child package which is working >>>and when it is done I delete the row,by this mechanism I control not 2 >>>child packages get executed at the same time(Because they do >>>transactional things on their own table, and I won;t tend to be stuck in >>>deadlocks). >>> >>> Problem is that I am expecting that two different child packages could >>> be executed at the same time but for some reason when Parent package >>> call one child package and it takes more than 3 minutes,none of the >>> other packages run.There is no any other instance of Parent package >>> running. >>> >>> When I schadule something ,it is supposed to be run at an specific >>> interval right? >>> >>> Thanks >>> >> >> > >
Thanks Allan,
My idea is now working.I schaduled the Parent package twice to be executed after 3 minutes (I have two jobs of the same parent package).As I siad child packages write their logs into a common table using a stored proc (with one simple insert and no transaction).Apparently everything is fine. [quoted text, click to view] > I am not sure how you do the check here I have information about each file in database ,and based on that information I decide which package I should execute.In the meantime I use a table to keep track of executing packages and by using that table I won;t let two instance of the same package run at the same time.Reason is that In child packages I call stored procedures which use Transactions and I don;t wnt to be tarpped by deallock or stuff like this ,that's why I came up with the idea of not letting two instances of the same child package run at the same time ,but I can have differnet instances of the child packages working simultaniously . Makes sense? Thanks [quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:%23qRakHKdFHA.4040@TK2MSFTNGP14.phx.gbl... > The same package cn be called at the same time multiple times. > > OK so what I think you are trying to do is this > > Fire a DTS package every 3 minutes (Parent) > In the parent package you check a csv file. Based on the CSV file you > call a package(Child) > > I am not sure how you do the check here. > > Would it be possible for you to fire the package based on an event? The > file being dropped? > > > -- > > > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) > www.SQLDTS.com - The site for all your DTS needs. > www.SQLIS.com - You thought DTS was good. here we show you the new stuff. > www.konesans.com - Consultancy from the people who know > > > "J-T" <J-T@nospam.com> wrote in message > news:e5OWyMHdFHA.3616@TK2MSFTNGP09.phx.gbl... >> Hi Allan, >> >> My parent package is a separte package than the child packages.I load the >> package based on the CSV file which is recieved in Parent package,then in >> an Activex script I load the appropriate package. >> >>> The same job cannot be run more than once at the same time. >> What a pitty,I thought it could be.Now the only option I have is that I >> can create two or three jobs of my Parent Package,can I? My only concern >> is that child packages logging the validation errors in one Table (That >> table is shared between all the child packages).Will I be stuck in dead >> lucks or something? I insert the log records by calling a stored >> procedure (no transaction involved) in child packages(there is a Execute >> SQL Task in each child package which referes to that stored procedure). >> >> Thanks for your help Allan (as always:-)) >> >> Cheers, >> >> >> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message >> news:OXTVqP$cFHA.3488@tk2msftngp13.phx.gbl... >>> The same job cannot be run more than once at the same time. >>> >>> A way to control child package exeution would be to link them through >>> workflow wouldn't it? >>> >>> >>> -- >>> >>> >>> >>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) >>> www.SQLDTS.com - The site for all your DTS needs. >>> www.SQLIS.com - You thought DTS was good. here we show you the new >>> stuff. >>> www.konesans.com - Consultancy from the people who know >>> >>> >>> "J-T" <J-T@nospam.com> wrote in message >>> news:ulaKIj4cFHA.412@tk2msftngp13.phx.gbl... >>>>I have a Parent package which call different child packages.I have >>>>schaduled the Parent package to be executed evey 3 minutes and I'm using >>>>a Table in which I insert the name of the child package which is working >>>>and when it is done I delete the row,by this mechanism I control not 2 >>>>child packages get executed at the same time(Because they do >>>>transactional things on their own table, and I won;t tend to be stuck in >>>>deadlocks). >>>> >>>> Problem is that I am expecting that two different child packages could >>>> be executed at the same time but for some reason when Parent package >>>> call one child package and it takes more than 3 minutes,none of the >>>> other packages run.There is no any other instance of Parent package >>>> running. >>>> >>>> When I schadule something ,it is supposed to be run at an specific >>>> interval right? >>>> >>>> Thanks >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |