Missing information in the report of an sql job

Document ID : KB000089961
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Missing information in the report of an sql job
Resolution:
Detailed Description and Symptoms

When executing an SQL job not all the information that was asked for through sql tab are being returned in the report.

For example:

.) The following SQL script is executed in a job:

 

SET IMPLICIT_TRANSACTIONS OFF

 

SET IMPLICIT_TRANSACTIONS OFF
select 1

print 'Step 1: successful'

select 1

print 'Step 2: successful'

Select 1

print 'Step 3: successful'

SET IMPLICIT_TRANSACTIONS ON

.) The Report returns the following:

1


1


1

Step 3: successful


Investigation

.) Only the last print is shown in the report, the two other prints

    are missing.

.) Return of the statements directly on the database through  

   SQL Management studio works correctly.

.) The Problems is on JDBC side, the error occured with JDBC 2.0

    Installing JDBC 3 solved the Problem.

?


Solution

.) Use the folling link to download JDBC 3 

   http://www.microsoft.com/download/en/details.aspx?id=21599

.) stop the agent

.) copy the sqljdbc_auth.dll into the bin folder of the agent

.) copy the sqljdbc.jar into the JDBC folder of the agent

   (Attention: if you are using a 64bit system please copy the  

     sqljdbc4.jar into the JDBC folder and rename it into sqljdbc.jar)

.) Restart the agent and run the job, now it should return all the

   information into the report, with the example given above the 

   sql job return the following information into the report after

   upgrading the JDBC driver->

1
 
 
1
 
 

1

Step 1: successful 
Step 2: successful

Step 3: successful

 

 

??