How can I get a backup schedule for all domains?

[Spazholio]

I would like to get a list of all my domains, when the domains are scheduled to be backed up, and (optionally) a list of successes/failures. I'll be happy with just the listing of schedules. Does anyone know how to do this?

[Monica]

Hello

It can be done by MySQL query in the database. The domain list is defined in the table "domains", the scheduled backup options are stored in the table BackupsScheduled. See the query to get the listing of all domains with scheduled backups:
mysql> select domains.name, domains.id, BackupsScheduled.obj_id, BackupsScheduled.last from domains, BackupsScheduled where domains.id=BackupsScheduled.obj_id;
Also, it is possible to run it at once from command line:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e"select domains.name, domains.id, BackupsScheduled.obj_id, BackupsScheduled.last from domains, BackupsScheduled where domains.id=BackupsScheduled.obj_id;"

[sergius]

I would like to get a list of all my domains, when the domains are scheduled to be backed up, and (optionally) a list of successes/failures. I'll be happy with just the listing of schedules. Does anyone know how to do this?

Hello Spazholio,

Please look at the Plesk online documentation

• Plesk for Unix
http://download1.swsoft.com/Plesk/Plesk8.4/Doc/en-US/plesk-8.4-unix-administrators-guide.pdf - Scheduling Backups, page 225
http://download1.swsoft.com/Plesk/Plesk8.4/Doc/en-US/plesk-8.4-unix-clients-guide.pdf - scheduling Backups, page 108
http://download1.swsoft.com/Plesk/Plesk8.4/Doc/en-US/plesk-8.4-unix-domain-administrators-guide.pdf - Scheduling Backups, page 96
• Plesk for Windows
http://download1.swsoft.com/Plesk/Plesk8.4/Doc/en-US/plesk-8.4-win-administrators-guide.pdf - Scheduling Backups, page 257
http://download1.swsoft.com/Plesk/Plesk8.4/Doc/en-US/plesk-8.4-win-backup-restore-guide.pdf - Scheduling Plesk Data Backups, page 17

[Spazholio]

sergius: while I appreciate the reply, none of these links have anything to do with my request. I know how to schedule a site to back up (which is what these show), but there is no way to run a report of when each site is scheduled and/or the last successful backup time (which these docs do not discuss). Monica's answer did the trick.