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.
| 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 serversIs 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 |
 |
|
|
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 |
|
|
|
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 |
|
|
|
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 |
|
|
|
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 |
|
|
|
|
|
|
Jobs canceled abruptly in a SQL server Client