Question Run Scheduled Tasks With Sql Command In Plesk

[Mahdi Elahi]

Hi,
I want Insert a record every minute in specified Table, but
how to set sql command for scheduled tasks in plesk ?
i upload a comman.sql in httpsdocs how to use it in scheduled tasks

 

[IgorG]

You can create simple bash script with command for sql insert inside and use this script in Command * field with full path.

 

[Mahdi Elahi]

How to do it?

 

[IgorG]

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.

 

[MarkM]

Run a mySQL query as a cron job?

 

[Mahdi Elahi]

Thanks , i create bash script and upload it on httpdocs , but in what write in Command scheduled task to execute the script file?
how to use it in scheduled task ?

i write in command filed
/zarbafco/bash.sh

but its not run and show this error
'/zarbafco/bash.sh' is not recognized as an internal or external command, operable program or batch file.
at Plesk impersonation(PipeServer::ServerThread::impersonateRunAs line 726)
at Task execution error(runtask::start line 182)

 

[IgorG]

Is it really full path to your script - /zarbafco/bash.sh ?
Did you this script executable as I wrote above?

 

[Mahdi Elahi]

i use this for path ,its true ?

 

[IgorG]

/root/bash/bash.sh is correct.
I hope that content of this script is correct too.
You can just run this script in CLI and check that it works as expected and record is added to database correctly.
After that you can run it as Scheduled task.

 

[Mahdi Elahi]

how to use windows cli or plesk cli ?

in windows i use sql server , is different between my sql or sql serve in bash.script

content of script
mysql --user=[zarbafco] --password=[*********] --database=[zarbafco_itisa] --execute="Insert into zarbafco_itisa.dbo.TSync1 (Id,Name,Age) Values (6,'Sara',25)"

 

[IgorG]

how to use windows cli or plesk cli ?

I meant Linuх Command Line Interface (CLI).

 

[Mahdi Elahi]

i dont use linux,
what i do ?

 

[IgorG]

i dont use linux,

Do you have Plesk installed on Linux server or on Windows server?

 

[Mahdi Elahi]

windows server

 

[IgorG]

windows server

Why didn't you say this before? Then all my recommendations are invalid. They are for Plesk installed on Linux server...

 

[Mahdi Elahi]

sorry , i dont khow,
whats different bettween linux and windows server for use scheduled task?

what i do now ?

 

[IgorG]

For Windows case it's better to use direct mysql command with insert for Command * field.
Maybe Windows experts will provide more relevant suggestions.

 

[Mahdi Elahi]

how to do it and use direct mysql command ?? show example please

 

[IgorG]

show example please

Question - Run Scheduled Tasks With Sql Command In Plesk

 

[Mahdi Elahi]

its use it for linux ?
Run a mySQL query as a cron job?