Home

SQL Job to output XML file

%3CLINGO-SUB%20id%3D%22lingo-sub-857080%22%20slang%3D%22en-US%22%3ESQL%20Job%20to%20output%20XML%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857080%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20I%20created%20a%20query%20that%20then%20outputs%20the%20query%20as%20XML.%20I%20created%20a%20job%20to%20run%20this%20query.%20However%2C%20the%20xml%20file%20being%20output%20contains%20the%20following%20data%20about%20the%20run%3A%3C%2FP%3E%3CP%3EJob%20'TestXML'%20%3A%20Step%201%2C%20'RunTest'%20%3A%20Began%20Executing%202019-09-16%2005%3A00%3A01%3C%2FP%3E%3CP%3EXML_F52E2B61-18A1-11d1-B105-00805F49916B%3CBR%20%2F%3E--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------%3C%2FP%3E%3CP%3EAnd%20then%20the%20number%20of%20rows%20affected.%26nbsp%3B%3CBR%20%2F%3EIs%20there%20any%20way%20to%20get%20rid%20of%20this%20data%2C%20so%20I%20have%20a%20valid%20XML%20document%20output%20when%20the%20job%20is%20run%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
stephen_madden
Occasional Visitor

Hello. I created a query that then outputs the query as XML. I created a job to run this query. However, the xml file being output contains the following data about the run:

Job 'TestXML' : Step 1, 'RunTest' : Began Executing 2019-09-16 05:00:01

XML_F52E2B61-18A1-11d1-B105-00805F49916B
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

And then the number of rows affected. 
Is there any way to get rid of this data, so I have a valid XML document output when the job is run?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies