if it doesn't show up in the 'job schedules' view we can do db query. what db server?
It doesn't show up in the job 'schedules' tab. That is where I was thinking I would find it.
Our database is an Oracle database.
WITH temp1 (group_id, path) AS
select group_id, cast(name as varchar(1000))
from blgroup bg1
where parent_group_id = 0
cast(bg2.path ||'/'|| cast(bg1.name as varchar(100)) as varchar(1000))
from blgroup bg1
inner join temp1 bg2 on bg1.parent_group_id = bg2.group_id
select temp1.path||'/'||j.name,r1.name as Created_by_role,u1.name as Created_by_user,r2.name as Modified_by_Role,u2.name as Modified_by_User,to_char(s.next_run_time,'YYYY-MM-DD HH24:MI:SS') as Next_run_time from temp1
inner join job j on temp1.group_id = j.group_id
inner join schedule s on j.job_id = s.job_id
join bluser u1 on s.created_by_user_id = u1.user_id
join blrole r1 on s.created_by_role_id = r1.role_id
join bluser u2 on s.modified_by_user_id = u2.user_id
join blrole r2 on s.modified_by_role_id = r2.role_id
where j.is_latest_version = 1
and j.is_deleted = 0
and j.is_saved_explicitly = 1
and s.next_run_time is not null
and s.is_deleted = 0
1 of 1 people found this helpful
What about the "Job Schedules View" in the GUI?
It shows you who scheduled the job. Much easier from my point of view :-)
Or you could do it that way! :-) Had never noticed that option before.
you said it didn't show in the job schedules tab ?
What Johannes recommended was something completely different from where I was originally looking (I was looking at the open job and going to the Schedules tab of that job). His recommendation was, from the GUI, select Configuration, Job Schedules View. This will open a tab that shows ALL scheduled jobs and their scheduling information.
Oh, i thought that’s where you were looking originally and didn’t double check ☺. Yeah, that’s the better way to do it.