We are running Decision Stream 6.5 on a WIN NT machine and it is writing to a SQL server database on a WIN 2003 machine. The job runs 12 DS jobstreams. on jobstream 11, the job appears to just hang. The first 10 steps write to other tables on the same database on the same server as step 11. If I use SQL enterprise manager and look at Current Activity, the DS job has spawned 2 processes -- one is blocking and the is being blocked by the first.
I tried to address this by putting the following statements into the PRE_P of the job step
$SQL_STRING := 'SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED';
LogMsg($SQL_STRING);
Sql('TARGET', $SQL_STRING);
This has no effect.
Please help!
-Dona
I tried to address this by putting the following statements into the PRE_P of the job step
$SQL_STRING := 'SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED';
LogMsg($SQL_STRING);
Sql('TARGET', $SQL_STRING);
This has no effect.
Please help!
-Dona