How can I save the job result to a file?
1
vote
2
answers
1612
views
I created a job in SQL Server. This job runs the following statement at regular intervals:
Select NationalIDNumber from HumanResources.Employee where BusinessEntityID = '1'
I want to save the result of this query to a txt file. I clicked **Advanced** on the Step tab for the job I created. I wrote the path there, but when the job was run, no records were added to the txt file.
What else should I do to add the job result to txt?
Advanced Tab : Output File --> D:\Data2\JobOutput.txt
Asked by Merve
(57 rep)
Jan 3, 2024, 06:47 AM
Last activity: Jan 16, 2024, 02:48 PM
Last activity: Jan 16, 2024, 02:48 PM