Hello Herbert, I modified some SQL from my MariaDB history. This gets jobs that were started or ended after the first of the month. Does this help at all?
``` set @TimeStamp := UNIX_TIMESTAMP(DATE_FORMAT(CURDATE(), '%Y-%m-01 00:00:00')); select `account`, `partition`, `id_user`, `id_group`, `cpus_req`, `mem_req`, `nodelist`, `nodes_alloc`, `node_inx`, `id_job`, `job_name`, `job_db_inx`, `timelimit`, from_unixtime(`time_submit`, '%Y/%m/%d %H:%i:%s') as 'time_submit_HUMAN', from_unixtime(`time_eligible`, '%Y/%m/%d %H:%i:%s') as 'time_eligible_HUMAN', from_unixtime(`time_start`, '%Y/%m/%d %H:%i:%s') as 'time_start_HUMAN', from_unixtime(`time_end`, '%Y/%m/%d %H:%i:%s') as 'time_end_HUMAN', from_unixtime(`mod_time`, '%Y/%m/%d %H:%i:%s') as 'mod_time_HUMAN', `time_submit`, `time_eligible`, `time_start`, `time_end`, `mod_time`, `state`, `derived_ec`, `exit_code`, `work_dir`, `submit_line`, `flags`, `id_array_job`, `id_array_task`, `tres_alloc`, `tres_req` from cluster_job_table where ( time_start >= @TimeStamp OR time_end >= @TimeStamp ) order by `account` asc, `partition` asc, `id_user` asc, `id_job` asc ; ``` -- slurm-users mailing list -- [email protected] To unsubscribe send an email to [email protected]
