stuzer05 / Oracle list jobs

Last active 5 days ago

Like 0

2 files changed, 21 insertions, 2 deletions

script.sql

script2.sql (file created)

1 file changed, 2 insertions, 19 deletions

script.sql

1 file changed, 19 insertions

script.sql (file created)

			@@ -1,2 +1,19 @@
1		-	select JOB, WHAT, THIS_DATE, THIS_SEC, NEXT_DATE, NEXT_SEC, BROKEN, INTERVAL, FAILURES from dba_jobs
2		-	where 1 = 1 AND WHAT like '%%'
	1	+	select owner as schema_name,
	2	+	job_name,
	3	+	job_style,
	4	+	case when job_type is null
	5	+	then 'PROGRAM'
	6	+	else job_type end as job_type,
	7	+	case when job_type is null
	8	+	then program_name
	9	+	else job_action end as job_action,
	10	+	start_date,
	11	+	case when repeat_interval is null
	12	+	then schedule_name
	13	+	else repeat_interval end as schedule,
	14	+	last_start_date,
	15	+	next_run_date,
	16	+	state
	17	+	from sys.all_scheduler_jobs
	18	+	order by owner,
	19	+	job_name;

			@@ -1,19 +1,2 @@
1		-	select owner as schema_name,
2		-	job_name,
3		-	job_style,
4		-	case when job_type is null
5		-	then 'PROGRAM'
6		-	else job_type end as job_type,
7		-	case when job_type is null
8		-	then program_name
9		-	else job_action end as job_action,
10		-	start_date,
11		-	case when repeat_interval is null
12		-	then schedule_name
13		-	else repeat_interval end as schedule,
14		-	last_start_date,
15		-	next_run_date,
16		-	state
17		-	from sys.all_scheduler_jobs
18		-	order by owner,
19		-	job_name;
	1	+	select JOB, WHAT, THIS_DATE, THIS_SEC, NEXT_DATE, NEXT_SEC, BROKEN, INTERVAL, FAILURES from dba_jobs
	2	+	where 1 = 1 AND WHAT like '%%'

		@@ -0,0 +1,19 @@
1	+	select owner as schema_name,
2	+	job_name,
3	+	job_style,
4	+	case when job_type is null
5	+	then 'PROGRAM'
6	+	else job_type end as job_type,
7	+	case when job_type is null
8	+	then program_name
9	+	else job_action end as job_action,
10	+	start_date,
11	+	case when repeat_interval is null
12	+	then schedule_name
13	+	else repeat_interval end as schedule,
14	+	last_start_date,
15	+	next_run_date,
16	+	state
17	+	from sys.all_scheduler_jobs
18	+	order by owner,
19	+	job_name;

		@@ -0,0 +1,2 @@
1	+	select JOB, WHAT, THIS_DATE, THIS_SEC, NEXT_DATE, NEXT_SEC, BROKEN, INTERVAL, FAILURES from dba_jobs
2	+	where 1 = 1 AND WHAT like '%%'