You are here: Re: DTS SQL JOB hangs even after the successful completion of the DTS « MsSQL Server « IT news, forums, messages
Re: DTS SQL JOB hangs even after the successful completion of the DTS

Posted by Pierre on 04/02/07 15:54

Hello,

Did you install SQLserver2005 SP2 ?

If yes, check the paramater RetainSameConnection under the connection
module , it seems to work different.

--
D'avance merci
Meilleures salutations
Pierre
"Query Builder" <querybuilder@gmail.com> a ιcrit dans le message de news:
1175274973.326162.224950@p77g2000hsh.googlegroups.com...
> Hi All,
>
> I have a DTS package that runs calling a few stored procedures and an
> activeX module. The package does some data cleanup and load. It takes
> an hour to complete. I have emails sent at the beginning and end of
> the package execution along with error notifications if any of the
> step fails.
>
> The issue is that, the DTS runs successfully. I ran the package from
> the server and it completes. If I schedule it, it has been running for
> over a few months without any issues. One fine day hell broke loose
> and it started to give an attitude!!
>
> When the job is invoked automatically on the scheduled time, it runs
> the package. Does what its supposed to do including sending out the
> final email. but is not finishing the job. The job says its still
> executing but the final step has completed. I have tried logging the
> package, and it says completed the last step.. But the JOB Log hasn't
> written anything to the log file.. (Job Log is where I am logging the
> step where I am calling the DTS).
>
> Has anyone have any idea what this issue is? I am at a dead end and
> have no clue why this is happening. I am thinking of changing the
> whole process but before that I want to try posting this.
>
> Any ideas, suggestions will be much appreciated. Please feel free to
> let me know if there is any additional information you need in order
> to troubleshoot this issue.
>
> Thanks in advance..
> Aravin.
>

 

Navigation:

[Reply to this message]


УдалСнная Ρ€Π°Π±ΠΎΡ‚Π° для программистов  •  Как Π·Π°Ρ€Π°Π±ΠΎΡ‚Π°Ρ‚ΡŒ Π½Π° Google AdSense  •  England, UK  •  ΡΡ‚Π°Ρ‚ΡŒΠΈ Π½Π° английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Π‘Π°ΠΉΡ‚ ΠΈΠ·Π³ΠΎΡ‚ΠΎΠ²Π»Π΅Π½ Π² Π‘Ρ‚ΡƒΠ΄ΠΈΠΈ Π’Π°Π»Π΅Π½Ρ‚ΠΈΠ½Π° ΠŸΠ΅Ρ‚Ρ€ΡƒΡ‡Π΅ΠΊΠ°
ΠΈΠ·Π³ΠΎΡ‚ΠΎΠ²Π»Π΅Π½ΠΈΠ΅ ΠΈ ΠΏΠΎΠ΄Π΄Π΅Ρ€ΠΆΠΊΠ° Π²Π΅Π±-сайтов, Ρ€Π°Π·Ρ€Π°Π±ΠΎΡ‚ΠΊΠ° ΠΏΡ€ΠΎΠ³Ρ€Π°ΠΌΠΌΠ½ΠΎΠ³ΠΎ обСспСчСния, поисковая оптимизация