I need help! I created and stored a session that connects to the host site and downloads the file. For the first time, it asks to you store the SSH key permanently. I did that. I created a script to automate the task.
Now I have created a SQL Server Agent Job and created a step that run the script. I want to automate the download step.
But when I run the job it hangs and does nothing. Basically it is nto working under the job but when I manually run the script it runs fine.
Please know that SQL Server Agent runs under different account.
I am not sure how to fix the problem. Pleaes help!!!