Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Jobs canceled abruptly in a SQL server Client

Author  Topic 

alejo46
Posting Yak Master

157 Posts

Posted - 2014-08-29 : 21:34:13
Good evening, the scenario is this: A server wehere there are DTS is calla Dtamart1 and a Server where Database is hosted DatamartSQL, there is client thirty part application that schedules and trigers those DTS that is ASutosys 11.

The seriuos hassles that has happened is suddenly some jobs (Called in A11) turn into a Terminiared Status and therefore all SP running failed and many of them go to rollback and finished.

This topis had been escalated to our DBA and our system Administrator but the say didn found anything strange in Database or general net work error or something like that between 2 SQL servers

Is it possible in the server where Autosys is running yilds tge problem ? how do i get around this ?

Thanks fot your help in advanced

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-08-30 : 02:11:06
As a first step on troubleshooting , try running the DTS without Autosys - does the DTS terminate abruptly?
Is there anything in the sql server agent error logs?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

alejo46
Posting Yak Master

157 Posts

Posted - 2014-08-30 : 20:14:33
casually i run a DTS in parallel and it kept working while in Autosys failed all running jobs and turn into s Terminated state
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-08-31 : 03:35:59
In that case , focus investigation on Autosys. Is this problem recent or has it just appeared?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-08-31 : 03:36:17
In that case , focus investigation on Autosys. Is this problem recent or has it just appeared?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

alejo46
Posting Yak Master

157 Posts

Posted - 2014-08-31 : 20:18:15
No sir,this problem has been been happening frequently from about 7 months ago and cause all running process triggered by the client Autosys end up rollinback
Go to Top of Page
   

- Advertisement -