Sep 16 2019 06:40 AM
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?