How to open remote desktop in a script, which runs as windows task?

Question

I am trying to import data from a remote server. My current approach is the create a script on the remote server, which is executed every time I log in using remote desktop. When I log in, a network share is mounted into the RDP session, and the script which is executed, copies a directory from the remote server to the mounted network share, thus making this directory locally available.

I want to automate this process, by creating a windows task. This task should log in a user in the remote server (RDP), and thus trigger the script execution. Is this a feasible method? Would it be possible to achieve this in another way?

Answer 1

Yes you can write a powershell script to do the needful and from task scheduler by adding action as "Program/Script: Powershell.exe" and argument should me your ps file location. Check the Microsoft link for detailed information on how to execute a powershell script in task scheduler.

Edited:

You can connect remote machine from poweshell using the command

Enter-PSSession -ComputerName computer_name

Steps to establish remote connection using power shell.