Monday, July 16, 2012 12:43 PM
Tuesday, July 17, 2012 5:42 AMModerator
Base on my research, when you run the string in command prompt, the %date will be parsed by command prompt first, and obtain the current date, then it was created in the csv file name. But when you run this in Task Scheduler, there is no mechanism like that, so the csv file cannot be created.
I find a workaround maybe you can try. Please follow the steps as below:
- Create a new bat file
- Type the string which you use and save the bat file
- In the Task Scheduler, right-click your task name, click Properties, click Actions tag, then click Edit, select Start a program as Action, and click Browse, select your bat file, click OK.
I did a similar test on this. Please see the following screenshot as reference:
Then you can run the task, and would find that the csv file can be generated successfully.
Tuesday, July 17, 2012 7:43 AM
Thank you for your explanation. Now its finally functioning. Both .cmd and .bat works :-)