SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 stop dts execution		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

eugz
Posting Yak Master

186 Posts
Posted - 01/03/2013 :  16:48:09  Show Profile  Reply with Quote
Hi All.

I ran SQL Server 2000 DTS. Now I need inter-up execution. I click Cancel button but task still executing. What need to do to stop DTS execution?

Thanks.

visakh16
Very Important crosS Applying yaK Herder

India
47969 Posts
Posted - 01/04/2013 :  02:24:22  Show Profile  Reply with Quote
are you running it from job or directly from DTS designer?
If from job you can stop job from sql server agent or use sp_stop_job procedure

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

eugz
Posting Yak Master

186 Posts
Posted - 01/07/2013 :  09:27:12  Show Profile  Reply with Quote
Hi visakh16. Happy New Year.

For instance, if my DTS name RDC_Load I need run stop procedure like:

EXEC dbo.sp_stop_job
N'RDC_Load' ;
GO

Is that correct?

Thanks.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47969 Posts
Posted - 01/07/2013 :  09:32:35  Show Profile  Reply with Quote
nope...the name should be name of the job and not name of DTS package

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

eugz
Posting Yak Master

186 Posts
Posted - 01/07/2013 :  09:57:37  Show Profile  Reply with Quote
Is a job means current executing task of DTS package? Is that correct?

Thanks.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47969 Posts
Posted - 01/07/2013 :  10:08:21  Show Profile  Reply with Quote
yep...the task you created in SQL Server Agent which calls the DTS package.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

eugz
Posting Yak Master

186 Posts
Posted - 01/07/2013 :  10:22:04  Show Profile  Reply with Quote
Sorry I confused. I have DTS package name RDC_Load that include ReloadRx, CustomerReview, RefreshProcess, and so on tasks. If I would like to stop DTS execution completely and current task executing RefreshProcess I need say:

EXEC dbo.sp_stop_job
N'RefreshProcess' ;
GO

By this way I can stop whole DTS package execution? Is that correct?

Thanks.
Edited by - eugz on 01/07/2013 10:24:18
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47969 Posts
Posted - 01/07/2013 :  10:33:39  Show Profile  Reply with Quote
nope... Remember my first question
How are you executing package? from DTS designer or from automated sql agent job?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

eugz
Posting Yak Master

186 Posts
Posted - 01/07/2013 :  10:49:30  Show Profile  Reply with Quote
I ran DTS package like:
In Enterprise Manager SQL Server 2000 I extend Data Transformation Services and select Local Packages. In the right side of screen I got list of DTS packages. I right-click on RDC_Load package and select Execute Package. What I need to do to stop execution RDC_Load package?

Thanks.
Edited by - eugz on 01/07/2013 11:00:37
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47969 Posts
Posted - 01/07/2013 :  11:30:21  Show Profile  Reply with Quote
then its directly running package from management studio. then only way is to stop it by selecting and stopping from enterprise manager

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

eugz
Posting Yak Master

186 Posts
Posted - 01/07/2013 :  11:36:54  Show Profile  Reply with Quote
That is exactly what I don't know how it to do. Can you detail explain how stop DTS in my case?

Thanks.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47969 Posts
Posted - 01/07/2013 :  11:40:42  Show Profile  Reply with Quote
do you mean you dont see stop button (red) in dts designer?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

eugz
Posting Yak Master

186 Posts
Posted - 01/07/2013 :  11:45:46  Show Profile  Reply with Quote
Can you detail explain how stop DTS in my case?

Thanks.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000