Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Agent job running query only sends half of the results to file Expand / Collapse
Author
Message
Posted Wednesday, October 10, 2012 9:28 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 28, 2013 5:13 AM
Points: 61, Visits: 721
I have an SQL Server Agent job running every day at 9am to run a query and using the Advanced tab in the specific step to run the query I send the output of the query to a CSV file. However, when checking the CSV file, only half of the results of the query display.

I'm using SQL server 2008 r2 and I save it to a CSV file on the network and then open it with Excel 2007 on my Windows 7 professional PC.

When I run the query itself outside of the job and save the results to a CSV file, the whole results show.

Any help greatly appreciated.
Post #1371007
Posted Wednesday, October 10, 2012 11:18 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 1:01 PM
Points: 643, Visits: 3,695
This thread looks promising as a solution....

http://social.msdn.microsoft.com/Forums/en-AU/transactsql/thread/ec9348c5-acbc-4ca7-8793-322847511460

http://msdn.microsoft.com/en-us/library/ms186238.aspx
Post #1371052
Posted Wednesday, October 10, 2012 2:02 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 28, 2013 5:13 AM
Points: 61, Visits: 721
Thanks, I'll give it a go tomorrow.
Post #1371107
Posted Thursday, October 11, 2012 2:30 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 28, 2013 5:13 AM
Points: 61, Visits: 721
Chrissy321 (10/10/2012)
This thread looks promising as a solution....

http://social.msdn.microsoft.com/Forums/en-AU/transactsql/thread/ec9348c5-acbc-4ca7-8793-322847511460

http://msdn.microsoft.com/en-us/library/ms186238.aspx


Sadly, this didn't work for me.
Post #1371283
Posted Thursday, October 11, 2012 8:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:32 AM
Points: 2,507, Visits: 3,643
Have to specified any size limit to the output file??
Post #1371533
Posted Thursday, October 11, 2012 8:27 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 28, 2013 5:13 AM
Points: 61, Visits: 721
I don't really understand the question. Do I have to specify a limit? No. I did try the set textsize option but this did not change the output for me.
Post #1371538
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse