Wanted to create a custom field on the Background Jobs page to easier identify background jobs that we can move to other queues that are candidates for optimization etc, but was struggeling with the syntax…. We created a Quick report instead
Here is the query if someone should have the same requirement. Would appreciate if someone have defined a custom field for this already and would share it here.
select job_id,
schedule_id,
description,
Client_SYS.Get_Item_Value('INTFACE_NAME',arguments_string) migration_job,
state,
state_db,
queue_id,
created,
posted,
started,
executed,
ROUND((executed - started) * 24 * 60) runtime_minutes,
username,
lang_code,
procedure_name,
error_text,
process_id
from deferred_job
where (('&Queue' IS NULL) OR ('&Queue' IS NOT NULL and queue_id = '&Queue'))
and (('&Runtime' IS NULL) OR ('&Runtime' IS NOT NULL and ROUND((executed - started) * 24 * 60) >= '&Runtime'))
and (('&CreatedDate' IS NULL) OR ('&CreatedDate' IS NOT NULL AND to_char(created,'DDMM') = '&CreatedDate'))
and (('&MigrationJob' IS NULL) OR ('&MigrationJob' IS NOT NULL and Client_SYS.Get_Item_Value('INTFACE_NAME',arguments_string) like upper('&MigrationJob')))
and (('&ScheduleId' IS NULL) OR ('&ScheduleId' IS NOT NULL and schedule_id = '&ScheduleId'))
order by job_id desc
Add as many details as possible, by providing details you’ll make it easier for others to reply