SQL Job to output XML file

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?

0 Replies