select first 1 * from sysadmin:ph_alert, sysadmin:ph_task where alert_task_id=tk_id and alert_type in ("WARNING","ERROR") and alert_state = "NEW" order by id desc;
id 80
alert_task_id 18
alert_task_seq 2
alert_type WARNING
alert_color GREEN
alert_time 2011-12-14 01:00:05
alert_state NEW
alert_state_chang+ 2011-12-14 01:00:05
alert_object_type MISC
alert_object_name
alert_message TASK NAME Auto Update Statistics Evaluation
LOCATION <UNKNOWN>
ERROR -212 Cannot add index.
ERROR -21522 No online index build possible
alert_action_dbs sysadmin
alert_action
tk_id 18
tk_name Auto Update Statistics Evaluation
tk_description To Evaluate which columns and tables should have the statis
tics and distributions refreshed.
tk_type TASK
tk_sequence 2
tk_result_table
tk_create
tk_dbs sysadmin
tk_execute aus_evaluator
tk_delete 0 01:00:00
tk_start_time 01:00:00
tk_stop_time 01:10:00
tk_frequency 1 00:00:00
tk_next_execution 2011-12-15 01:00:00
tk_total_executio+ 1
tk_total_time 5.186699829479
tk_monday t
tk_tuesday t
tk_wednesday t
tk_thursday t
tk_friday t
tk_saturday t
tk_sunday t
tk_attributes 412
tk_group PERFORMANCE
tk_enable t
tk_priority 0