Sample Header Ad - 728x90

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