PLESK scheduled task creating a scheduled task to call a mysql stored procedure

To create a scheduled task log in to plesk and go to Tools & Settings. 
Click on  Scheduled Tasks

Now click on Add Task

Now select task type  Run Command
To run mysql command set command to mysql 
Specify the arguments in the with arguments text box. Enter the arguments like the one here

-e "use `your_database_name`;call your_stored_procedure_name();\g" --user=your_user_name --password=your_password

Make  sure you add \g at the end of the sql statement. If you are connecting to another server then specify it using --host=your_target_host_ip

Now Specify the time and frequency of execution in the Run option. Choose daily and type the time you want this task to be run each day. You can run hourly, weekly, monthly, yearly also.

Now enter a description about this task in the Description text box.
Finally in the Notify section select an appropriate mode and press Ok.