When I schedule any job using dba calender the program used is
rsdbajob. For eg DBA:REORGCK_ALL_____@170000/2000 and
DBA:RUNSTAT_TAB_____@230000/2000 both use the same program rsdbajob.
How does the scheduler distinguish amongst the two ?
I thought may be using the variant but it also differs and is not
constant for a job. A new variant is created each time you create a job.i.e when i schedule the same job twice say
DBA:REORGCK_ALL_____@170000/2000 the jobs have different varients in
the form &0000000000023 and &0000000000024.
So my questions are:
1) how does the scheduler distinguish between reorg and runstats job which both run the same program rsdbajob ?
2) what is the use of the variant (&0000000000024) and why is a new one created each time ?