Question Run Scheduled Tasks With Sql Command In Plesk

[Mahdi Elahi]

how to run query in scheduled tasks for windows server ?

 

[JamesBlack]

To do what?

Create script databaseupdate.sh with content like:

#!/bin/bash
plesk db "INSERT INTO databasename.tablename ....."


make your script executable with

# chmod +x /path/to/databaseupdate.sh

then specify this script with full path (like /path/to/databaseupdate.sh) in Command* filed of screen above.

I have a similar problem. Thanks, it helped me with Linux.