Cloudstack Viewing snapshot Scheduled Tasks

Directly on SQL:

Select     v.name as vm_instance_name,    v.vo_name  as volume_name,    date_format (Date_add (sn.scheduled_timestamp,                 interval 8 hour) ,             '%y-%m-%d %h:%i:%s %w ')  AS next_schedule_dateFROM    cloud.snapshot_schedule AS sn         JOIN     (select          vo.id as vo_id, vo.name as vo_name, vm.id, vm.name     from        cloud.vm_instance as vm     JOIN CLOUD.VOLUMES AS VO ON VM.ID = VO.INSTANCE_ID)  as v on sn.volume_id = v.vo_id; 

Show 3 fields

Instance name volume name Next execution time

This time is coming through +8.

Effects such as:

+------------------+-------------+----------------------------+| vm_instance_name | volume_name  | next_schedule_date         |+------------------+---- ---------+----------------------------+| xxx               | root-85     | 15-08-30 01:00:00 sunday    | |  xxx              | root-87      | 15-08-30 01:00:00 sunday   | |  xxx           | xxxx | 15-08-29  01:00:00 saturday | |  xxx           | ROOT-361     | 15-08-30 01:00:00 sunday   | |  xxx          | root-365    | 15-08-29  01:00:00 saturday |+------------------+-------------+----------------------------+

Cloudstack Viewing snapshot Scheduled Tasks