root/trunk/autonomous_logging_tool/autonomous_logging_tool.test.sql

Revision 3, 1.4 kB (checked in by robert, 7 years ago)

autonomous logging tool, uses dblink

Line 
1 select add_job('Job 1');
2 select * from job_log order by job_id;
3
4 select add_step(1,'Step 1 For Job 1');
5 select * from job_log join job_details using (job_id) order by job_id, step_id;
6
7 select upd_step(1,1,'OK','Update 1 For Step 1 For Job 1');
8 select * from job_log join job_details using (job_id) order by job_id, step_id;
9
10 select add_step(1,'Step 2 For Job 1');
11 select * from job_log join job_details using (job_id) order by job_id, step_id;
12
13 select upd_step(1,2,'','Update 1 For Step 2 For Job 1');
14 select * from job_log join job_details using (job_id) order by job_id, step_id;
15
16 select upd_step(1,2,'','Update 2 For Step 2 For Job 1');
17 select * from job_log join job_details using (job_id) order by job_id, step_id;
18
19 select upd_step(1,2,'OK','Update 3 For Step 2 For Job 1');
20 select * from job_log join job_details using (job_id) order by job_id, step_id;
21
22 select close_job(1);
23 select * from job_log join job_details using (job_id) order by job_id, step_id;
24
25
26 select add_job('Job 2');
27 select * from job_log order by job_id;
28
29 select add_step(2,'Step 1 For Job 2');
30 select * from job_log join job_details using (job_id) order by job_id, step_id;
31
32 select upd_step(2,1,'OK','Update 1 For Step 1 For Job 2');
33 select * from job_log join job_details using (job_id) order by job_id, step_id;
34
35 select fail_job(2);
36 select * from job_log join job_details using (job_id) order by job_id, step_id;
Note: See TracBrowser for help on using the browser.