PowerShell Schedule Task

Question

Hello,

I have powershell script to insert some data into SQL server, when i double click on the .ps1 file i can see the data in SQL server.

Then i want to make this script running every hours and i schedule this using windows task scheduler.

But unfortunately when this scrip running as schedule, the task schedule log say the script running successfully but i cannot see any data in the SQL server. Anyone know why?

Answer 1

Handian,

Like Rich's comment mentioned, I would verify the account used to run the task has the proper permissions to SQL and the folder path listed. Also, the argument list for your task may need to look a little something like the below.

"& 'D:\SFTP_Root\Script-Insert-Backup-To-DB.ps1'"

This means your Details column should look like the below.

powershell.exe "& 'D:\SFTP_Root\Script-Insert-Backup-To-DB.ps1'"

Let me know if that ended up helping out!

Regards,

Christopher