DTS Hanged When Scheduled

#21

I also am having this problem on a few of my scheduled jobs. 5 work, and 3
stopped working 2 weeks ago. The DTS element finishes and the data loads,
but the scheduled job does not finish. DTS log indicates that the job has
finished but doesn't seem to get a message to the agent.

I have set the "Execute on main package thread" as the paper recommends,
but with no success.

Any suggestions?

Thanks.

Caoimhgh

"Adams Qu [MSFT]" wrote:

Quote:

Dear Walty,

How's everything going?

I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need any
additional help.

Have a nice day!

Best regards,

Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support

Microsoft Global Technical Support Center

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| X-Tomcat-ID: 31480295
| References: <e9hm5QIeIHA.5620 (AT) TK2MSFTNGP04 (DOT) phx.gbl
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu (AT) online (DOT) microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Wed, 27 Feb 2008 03:06:37 GMT
| Subject: RE: DTS Hanged When Scheduled
| X-Tomcat-NG: microsoft.public.sqlserver.dts
| Message-ID: <uGn5E3OeIHA.4200 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
| Newsgroups: microsoft.public.sqlserver.dts
| Lines: 74
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:4753
| NNTP-Posting-Host: tk5tomimport1.phx.gbl 10.201.218.19
|
| Dear Walty,
|
| Thank you for posting here.
|
| Based on my research, this behavior occurs because the package is using
| providers, drivers, or DLLs that are apartment threaded or that are not
| thread-safe. In such situation, a DTS package may raise exceptions or
stop
| responding (hang) when you run it as a SQL Server Agent scheduled job.
|
| As a resolution or workaround, please click the "Execute on main package
| thread" option on the Workflow Property tab for the Transform Data task,
or
| ActiveX Script task step that uses apartment-threaded third-party drivers
| or DLLs. Turn on DTS package logging to determine at which step the
failure
| occurs. If the package log indicates that all steps have succeeded, turn
on
| "Execute on main package thread" for each Transform Data task or ActiveX
| Script task that uses apartment-threaded drivers, providers, or DLLs.
|
| Below is the related KB article for this behavior:
|
| PRB: A DTS Package Raises Exceptions or Stops Responding When You Run It
as
| a Scheduled Job
| http://support.microsoft.com/?id=318819
|
| If anything is unclear in my post, please don't hesitate to let me know.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu
| MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| ================================================== ===
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| ================================================== ===
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
| --------------------
| | Date: Tue, 26 Feb 2008 22:31:05 +0800
| | From: Walty <walty (AT) community (DOT) nospam
| | User-Agent: Thunderbird 2.0.0.6 (X11/20071008)
| | MIME-Version: 1.0
| | Subject: DTS Hanged When Scheduled
| | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| | Content-Transfer-Encoding: 7bit
| | Message-ID: <e9hm5QIeIHA.5620 (AT) TK2MSFTNGP04 (DOT) phx.gbl
| | Newsgroups: microsoft.public.sqlserver.dts
| | NNTP-Posting-Host: 221.127.144.125
| | Lines: 1
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP04.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:4745
| | X-Tomcat-NG: microsoft.public.sqlserver.dts
| |
| | Hi,
| |
| | I have a couples of DTS jobs set up for data import from Oracle to SQL
| | server. They all appear to run fine when triggered manually. However,
| | when they are scheduled to run routinely in SQL server job agent,
these
| | jobs may OCCASIONALLY got hanged. Some jobs which normally finish
within
| | hours (or even less than ten minutes) will hold on for more than 24
| | hours. They don't finish or fail, just hang there. However, when the
DTS
| | jobs are run manually (inside the DTS designer), this scenario never
| | appear. Any idea please?
| |
| | Thanks a lot.
| |
| | have a nice day
| | walty
| |
|
|

#22

I also am having this problem on a few of my scheduled jobs. 5 work, and 3
stopped working 2 weeks ago. The DTS element finishes and the data loads,
but the scheduled job does not finish. DTS log indicates that the job has
finished but doesn't seem to get a message to the agent.

I have set the "Execute on main package thread" as the paper recommends,
but with no success.

Any suggestions?

Thanks.

Caoimhgh

"Adams Qu [MSFT]" wrote:

Quote:

Dear Walty,

How's everything going?

I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need any
additional help.

Have a nice day!

Best regards,

Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support

Microsoft Global Technical Support Center

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| X-Tomcat-ID: 31480295
| References: <e9hm5QIeIHA.5620 (AT) TK2MSFTNGP04 (DOT) phx.gbl
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu (AT) online (DOT) microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Wed, 27 Feb 2008 03:06:37 GMT
| Subject: RE: DTS Hanged When Scheduled
| X-Tomcat-NG: microsoft.public.sqlserver.dts
| Message-ID: <uGn5E3OeIHA.4200 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
| Newsgroups: microsoft.public.sqlserver.dts
| Lines: 74
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:4753
| NNTP-Posting-Host: tk5tomimport1.phx.gbl 10.201.218.19
|
| Dear Walty,
|
| Thank you for posting here.
|
| Based on my research, this behavior occurs because the package is using
| providers, drivers, or DLLs that are apartment threaded or that are not
| thread-safe. In such situation, a DTS package may raise exceptions or
stop
| responding (hang) when you run it as a SQL Server Agent scheduled job.
|
| As a resolution or workaround, please click the "Execute on main package
| thread" option on the Workflow Property tab for the Transform Data task,
or
| ActiveX Script task step that uses apartment-threaded third-party drivers
| or DLLs. Turn on DTS package logging to determine at which step the
failure
| occurs. If the package log indicates that all steps have succeeded, turn
on
| "Execute on main package thread" for each Transform Data task or ActiveX
| Script task that uses apartment-threaded drivers, providers, or DLLs.
|
| Below is the related KB article for this behavior:
|
| PRB: A DTS Package Raises Exceptions or Stops Responding When You Run It
as
| a Scheduled Job
| http://support.microsoft.com/?id=318819
|
| If anything is unclear in my post, please don't hesitate to let me know.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu
| MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| ================================================== ===
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| ================================================== ===
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
| --------------------
| | Date: Tue, 26 Feb 2008 22:31:05 +0800
| | From: Walty <walty (AT) community (DOT) nospam
| | User-Agent: Thunderbird 2.0.0.6 (X11/20071008)
| | MIME-Version: 1.0
| | Subject: DTS Hanged When Scheduled
| | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| | Content-Transfer-Encoding: 7bit
| | Message-ID: <e9hm5QIeIHA.5620 (AT) TK2MSFTNGP04 (DOT) phx.gbl
| | Newsgroups: microsoft.public.sqlserver.dts
| | NNTP-Posting-Host: 221.127.144.125
| | Lines: 1
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP04.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:4745
| | X-Tomcat-NG: microsoft.public.sqlserver.dts
| |
| | Hi,
| |
| | I have a couples of DTS jobs set up for data import from Oracle to SQL
| | server. They all appear to run fine when triggered manually. However,
| | when they are scheduled to run routinely in SQL server job agent,
these
| | jobs may OCCASIONALLY got hanged. Some jobs which normally finish
within
| | hours (or even less than ten minutes) will hold on for more than 24
| | hours. They don't finish or fail, just hang there. However, when the
DTS
| | jobs are run manually (inside the DTS designer), this scenario never
| | appear. Any idea please?
| |
| | Thanks a lot.
| |
| | have a nice day
| | walty
| |
|
|

#23

I also am having this problem on a few of my scheduled jobs. 5 work, and 3
stopped working 2 weeks ago. The DTS element finishes and the data loads,
but the scheduled job does not finish. DTS log indicates that the job has
finished but doesn't seem to get a message to the agent.

I have set the "Execute on main package thread" as the paper recommends,
but with no success.

Any suggestions?

Thanks.

Caoimhgh

"Adams Qu [MSFT]" wrote:

Quote:

Dear Walty,

How's everything going?

I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need any
additional help.

Have a nice day!

Best regards,

Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support

Microsoft Global Technical Support Center

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| X-Tomcat-ID: 31480295
| References: <e9hm5QIeIHA.5620 (AT) TK2MSFTNGP04 (DOT) phx.gbl
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu (AT) online (DOT) microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Wed, 27 Feb 2008 03:06:37 GMT
| Subject: RE: DTS Hanged When Scheduled
| X-Tomcat-NG: microsoft.public.sqlserver.dts
| Message-ID: <uGn5E3OeIHA.4200 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
| Newsgroups: microsoft.public.sqlserver.dts
| Lines: 74
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:4753
| NNTP-Posting-Host: tk5tomimport1.phx.gbl 10.201.218.19
|
| Dear Walty,
|
| Thank you for posting here.
|
| Based on my research, this behavior occurs because the package is using
| providers, drivers, or DLLs that are apartment threaded or that are not
| thread-safe. In such situation, a DTS package may raise exceptions or
stop
| responding (hang) when you run it as a SQL Server Agent scheduled job.
|
| As a resolution or workaround, please click the "Execute on main package
| thread" option on the Workflow Property tab for the Transform Data task,
or
| ActiveX Script task step that uses apartment-threaded third-party drivers
| or DLLs. Turn on DTS package logging to determine at which step the
failure
| occurs. If the package log indicates that all steps have succeeded, turn
on
| "Execute on main package thread" for each Transform Data task or ActiveX
| Script task that uses apartment-threaded drivers, providers, or DLLs.
|
| Below is the related KB article for this behavior:
|
| PRB: A DTS Package Raises Exceptions or Stops Responding When You Run It
as
| a Scheduled Job
| http://support.microsoft.com/?id=318819
|
| If anything is unclear in my post, please don't hesitate to let me know.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu
| MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| ================================================== ===
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| ================================================== ===
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
| --------------------
| | Date: Tue, 26 Feb 2008 22:31:05 +0800
| | From: Walty <walty (AT) community (DOT) nospam
| | User-Agent: Thunderbird 2.0.0.6 (X11/20071008)
| | MIME-Version: 1.0
| | Subject: DTS Hanged When Scheduled
| | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| | Content-Transfer-Encoding: 7bit
| | Message-ID: <e9hm5QIeIHA.5620 (AT) TK2MSFTNGP04 (DOT) phx.gbl
| | Newsgroups: microsoft.public.sqlserver.dts
| | NNTP-Posting-Host: 221.127.144.125
| | Lines: 1
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP04.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:4745
| | X-Tomcat-NG: microsoft.public.sqlserver.dts
| |
| | Hi,
| |
| | I have a couples of DTS jobs set up for data import from Oracle to SQL
| | server. They all appear to run fine when triggered manually. However,
| | when they are scheduled to run routinely in SQL server job agent,
these
| | jobs may OCCASIONALLY got hanged. Some jobs which normally finish
within
| | hours (or even less than ten minutes) will hold on for more than 24
| | hours. They don't finish or fail, just hang there. However, when the
DTS
| | jobs are run manually (inside the DTS designer), this scenario never
| | appear. Any idea please?
| |
| | Thanks a lot.
| |
| | have a nice day
| | walty
| |
|
|

#24

I also am having this problem on a few of my scheduled jobs. 5 work, and 3
stopped working 2 weeks ago. The DTS element finishes and the data loads,
but the scheduled job does not finish. DTS log indicates that the job has
finished but doesn't seem to get a message to the agent.

I have set the "Execute on main package thread" as the paper recommends,
but with no success.

Any suggestions?

Thanks.

Caoimhgh

"Adams Qu [MSFT]" wrote:

Quote:

Dear Walty,

How's everything going?

I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need any
additional help.

Have a nice day!

Best regards,

Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support

Microsoft Global Technical Support Center

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| X-Tomcat-ID: 31480295
| References: <e9hm5QIeIHA.5620 (AT) TK2MSFTNGP04 (DOT) phx.gbl
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu (AT) online (DOT) microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Wed, 27 Feb 2008 03:06:37 GMT
| Subject: RE: DTS Hanged When Scheduled
| X-Tomcat-NG: microsoft.public.sqlserver.dts
| Message-ID: <uGn5E3OeIHA.4200 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
| Newsgroups: microsoft.public.sqlserver.dts
| Lines: 74
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:4753
| NNTP-Posting-Host: tk5tomimport1.phx.gbl 10.201.218.19
|
| Dear Walty,
|
| Thank you for posting here.
|
| Based on my research, this behavior occurs because the package is using
| providers, drivers, or DLLs that are apartment threaded or that are not
| thread-safe. In such situation, a DTS package may raise exceptions or
stop
| responding (hang) when you run it as a SQL Server Agent scheduled job.
|
| As a resolution or workaround, please click the "Execute on main package
| thread" option on the Workflow Property tab for the Transform Data task,
or
| ActiveX Script task step that uses apartment-threaded third-party drivers
| or DLLs. Turn on DTS package logging to determine at which step the
failure
| occurs. If the package log indicates that all steps have succeeded, turn
on
| "Execute on main package thread" for each Transform Data task or ActiveX
| Script task that uses apartment-threaded drivers, providers, or DLLs.
|
| Below is the related KB article for this behavior:
|
| PRB: A DTS Package Raises Exceptions or Stops Responding When You Run It
as
| a Scheduled Job
| http://support.microsoft.com/?id=318819
|
| If anything is unclear in my post, please don't hesitate to let me know.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu
| MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| ================================================== ===
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| ================================================== ===
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
| --------------------
| | Date: Tue, 26 Feb 2008 22:31:05 +0800
| | From: Walty <walty (AT) community (DOT) nospam
| | User-Agent: Thunderbird 2.0.0.6 (X11/20071008)
| | MIME-Version: 1.0
| | Subject: DTS Hanged When Scheduled
| | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| | Content-Transfer-Encoding: 7bit
| | Message-ID: <e9hm5QIeIHA.5620 (AT) TK2MSFTNGP04 (DOT) phx.gbl
| | Newsgroups: microsoft.public.sqlserver.dts
| | NNTP-Posting-Host: 221.127.144.125
| | Lines: 1
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP04.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:4745
| | X-Tomcat-NG: microsoft.public.sqlserver.dts
| |
| | Hi,
| |
| | I have a couples of DTS jobs set up for data import from Oracle to SQL
| | server. They all appear to run fine when triggered manually. However,
| | when they are scheduled to run routinely in SQL server job agent,
these
| | jobs may OCCASIONALLY got hanged. Some jobs which normally finish
within
| | hours (or even less than ten minutes) will hold on for more than 24
| | hours. They don't finish or fail, just hang there. However, when the
DTS
| | jobs are run manually (inside the DTS designer), this scenario never
| | appear. Any idea please?
| |
| | Thanks a lot.
| |
| | have a nice day
| | walty
| |
|
|

#25

I also am having this problem on a few of my scheduled jobs. 5 work, and 3
stopped working 2 weeks ago. The DTS element finishes and the data loads,
but the scheduled job does not finish. DTS log indicates that the job has
finished but doesn't seem to get a message to the agent.

I have set the "Execute on main package thread" as the paper recommends,
but with no success.

Any suggestions?

Thanks.

Caoimhgh

"Adams Qu [MSFT]" wrote:

Quote:

Dear Walty,

How's everything going?

I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need any
additional help.

Have a nice day!

Best regards,

Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support

Microsoft Global Technical Support Center

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| X-Tomcat-ID: 31480295
| References: <e9hm5QIeIHA.5620 (AT) TK2MSFTNGP04 (DOT) phx.gbl
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu (AT) online (DOT) microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Wed, 27 Feb 2008 03:06:37 GMT
| Subject: RE: DTS Hanged When Scheduled
| X-Tomcat-NG: microsoft.public.sqlserver.dts
| Message-ID: <uGn5E3OeIHA.4200 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
| Newsgroups: microsoft.public.sqlserver.dts
| Lines: 74
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:4753
| NNTP-Posting-Host: tk5tomimport1.phx.gbl 10.201.218.19
|
| Dear Walty,
|
| Thank you for posting here.
|
| Based on my research, this behavior occurs because the package is using
| providers, drivers, or DLLs that are apartment threaded or that are not
| thread-safe. In such situation, a DTS package may raise exceptions or
stop
| responding (hang) when you run it as a SQL Server Agent scheduled job.
|
| As a resolution or workaround, please click the "Execute on main package
| thread" option on the Workflow Property tab for the Transform Data task,
or
| ActiveX Script task step that uses apartment-threaded third-party drivers
| or DLLs. Turn on DTS package logging to determine at which step the
failure
| occurs. If the package log indicates that all steps have succeeded, turn
on
| "Execute on main package thread" for each Transform Data task or ActiveX
| Script task that uses apartment-threaded drivers, providers, or DLLs.
|
| Below is the related KB article for this behavior:
|
| PRB: A DTS Package Raises Exceptions or Stops Responding When You Run It
as
| a Scheduled Job
| http://support.microsoft.com/?id=318819
|
| If anything is unclear in my post, please don't hesitate to let me know.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu
| MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| ================================================== ===
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| ================================================== ===
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
| --------------------
| | Date: Tue, 26 Feb 2008 22:31:05 +0800
| | From: Walty <walty (AT) community (DOT) nospam
| | User-Agent: Thunderbird 2.0.0.6 (X11/20071008)
| | MIME-Version: 1.0
| | Subject: DTS Hanged When Scheduled
| | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| | Content-Transfer-Encoding: 7bit
| | Message-ID: <e9hm5QIeIHA.5620 (AT) TK2MSFTNGP04 (DOT) phx.gbl
| | Newsgroups: microsoft.public.sqlserver.dts
| | NNTP-Posting-Host: 221.127.144.125
| | Lines: 1
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP04.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:4745
| | X-Tomcat-NG: microsoft.public.sqlserver.dts
| |
| | Hi,
| |
| | I have a couples of DTS jobs set up for data import from Oracle to SQL
| | server. They all appear to run fine when triggered manually. However,
| | when they are scheduled to run routinely in SQL server job agent,
these
| | jobs may OCCASIONALLY got hanged. Some jobs which normally finish
within
| | hours (or even less than ten minutes) will hold on for more than 24
| | hours. They don't finish or fail, just hang there. However, when the
DTS
| | jobs are run manually (inside the DTS designer), this scenario never
| | appear. Any idea please?
| |
| | Thanks a lot.
| |
| | have a nice day
| | walty
| |
|
|

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Hanged When Scheduled

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

RE: DTS Hanged When Scheduled - 05-27-2008 , 12:18 PM

RE: DTS Hanged When Scheduled - 05-27-2008 , 12:18 PM

RE: DTS Hanged When Scheduled - 05-27-2008 , 12:18 PM

RE: DTS Hanged When Scheduled - 05-27-2008 , 12:18 PM

RE: DTS Hanged When Scheduled - 05-27-2008 , 12:18 PM