Jobs

SELECT r_object_id, object_name,run_mode, a_special_app,

start_date, a_last_invocation, a_last_completion,a_next_invocation

FROM dm_job

WHERE run_now = true

OR a_special_app = 'agentexec'

select * from dm_job where a_special_app = 'agentexec'

update dm_job object

set a_next_invocation = DATE('06/08/2015 10:30:00','dd/mm/yyyy hh:mi:ss'),

set run_now = true

update dm_job object

set a_special_app = '',

set a_current_status = 'ABORTED',

set a_last_completion = DATE(NOW),

set run_now = false

where object_name = '<job_name>'

select object_name, r_object_id, a_last_invocation, a_last_completion, a_last_process_id, a_current_status

from dm_job where a_special_app = 'agentexec'

order by a_last_process_id

SELECT r_object_id,run_mode, is_inactive, object_name,

start_date,expiration_date, a_last_invocation, a_last_completion,

a_next_invocation, a_current_status

FROM dm_job

WHERE object_name in (

'dm_DMClean','dm_DMFilescan','dm_QueueMgt','dm_LogPurge',

'dm_LDAPSynchronization','dm_AuditMgt','dm_UpdateStats'

) ORDER BY a_next_invocation