/i VdjSQL_Insert_SMP_VDJ_JOBLjava/lang/String; ConstantValue VdjSQL_Delete_SMP_VDJ_JOB VdjSQL_RowLock_SMP_VDJ_JOB VdjSQL_ActiveUpdate_SMP_VDJ_JOB  VdjSQL_LibraryUpdate_SMP_VDJ_JOB VdjSQL_Retrieve_SMP_VDJ_JOB"retrieve_SMP_VDJ_JOB_timeZoneIndexI!retrieve_SMP_VDJ_JOB_jobNameIndexretrieve_SMP_VDJ_JOB_ownerIndex%retrieve_SMP_VDJ_JOB_descriptionIndex!retrieve_SMP_VDJ_JOB_appNameIndex$retrieve_SMP_VDJ_JOB_targetTypeIndex"retrieve_SMP_VDJ_JOB_scheduleIndex$retrieve_SMP_VDJ_JOB_submitTimeIndex!retrieve_SMP_VDJ_JOB_isFixitIndex retrieve_SMP_VDJ_JOB_isLibIndex #retrieve_SMP_VDJ_JOB_lastModByIndex %retrieve_SMP_VDJ_JOB_lastModTimeIndex $retrieve_SMP_VDJ_JOB_incompleteIndex +retrieve_SMP_VDJ_JOB_overrideNodeCredsIndex"VdjSQL_Retrieve_Active_Job_Targets VdjSQL_Retrieve_JobInfoForSubmitVdjSQL_Retrieve_Timesretrieve_Times_timeZoneIndexretrieve_Times_submitTimeIndexretrieve_Times_lastModTimeIndexVdjSQL_JobID_Given_NameAndOwnerVdjSQL_JobInfo_Given_JobIDVdjSQL_JobIDs_Given_OwnerVdjSQL_Jobs_Given_OwnerVdjSQL_Get_All_Job_LibsVdjSQL_Get_All_Fixit_JobsVdjSQL_Get_Distinct_Fixit_Jobs+VdjSQL_Get_Distinct_Fixit_Jobs_JTTargetName/get_Distinct_Fixit_Jobs_with_Targets_jobIdIndex1get_Distinct_Fixit_Jobs_with_Targets_jobNameIndex/get_Distinct_Fixit_Jobs_with_Targets_ownerIndexVdjSQL_Get_Job_Libs_Of_Owner%VdjSQL_Get_Job_Libs_Of_Owner_and_Name)get_Job_Libs_Of_Owner_and_Name_jobIdIndexVdjSQL_getJobLibResultSetVdjSQL_job_id_CnameVdjSQL_getSubmittedJobListVdjSQL_getAllSubmittedJobsVdjSQL_getIsLib VdjSQL_TargetType_Given_JobID!VdjSQL_LockTable_SMP_VDJ_JOB"VdjSQL_insertJob#VdjSQL_insertJob_jobIdIndex(VdjSQL_insertJob_targetsWithoutCredIndex&VdjSQL_insertJob_nodesWithoutCredIndex VdjSQL_insertJob_numTargetsIndex*VdjSQL_insertJob_targetsWithoutAgentsIndexVdjSQL_insertNotifs$VdjSQL_updateNodeCreds%$VdjSQL_Insert_SMP_VDJ_JOB_PER_TARGET&$VdjSQL_Update_SMP_VDJ_JOB_PER_TARGET'+VdjSQL_GetDeregPerId_SMP_VDJ_JOB_PER_TARGET(&VdjSQL_Retrieve_SMP_VDJ_JOB_PER_TARGET),VdjSQL_RetrieveActive_SMP_VDJ_JOB_PER_TARGET*$VdjSQL_RetrieveAllActiveJobsOnTarget+$VdjSQL_Delete_SMP_VDJ_JOB_PER_TARGET,*VdjSQL_Delete_SMP_VDJ_JOB_PER_TARGET_jobId-3VdjSQL_Delete_SMP_VDJ_JOB_PER_TARGET_nonactive_list.VdjSQL_removeAllJobLogs/VdjSQL_processClearHistoryTrunc0VdjSQL_processClearHistoryMark1+VdjSQL_Retrieve_SMP_VDJ_JOB_PER_TARGET_info21VdjSQL_RetrieveActive_SMP_VDJ_JOB_PER_TARGET_info30retrieve_SMP_VDJ_JOB_PER_TARGET_info_statusIndex4retrieve_SMP_VDJ_JOB_PER_TARGET_info_targetNameIndex2retrieve_SMP_VDJ_JOB_PER_TARGET_info_nodeNameIndex7VdjSQL_Retrieve_SMP_VDJ_JOB_PER_TARGET_info_with_target41VdjSQL_Retrieve_SMP_VDJ_JOB_PER_TARGET_active_job5VdjSQL_RetrieveOwnedActiveJobs6VdjSQL_CrsUserClause7VdjSQL_CrsSuperUserClause8VdjSQL_jobs_suTable9VdjSQL_jobs_userTable:VdjSQL_getActiveJobs;VdjSQL_getNormActiveJobs<'VdjSQL_DeleteJob_SMP_VDJ_JOB_PER_TARGET='VdjSQL_SMP_VDJ_JOB_PER_TARGET_scheduled>/VdjSQL_SMP_VDJ_JOB_PER_TARGET_update_start_time?0VdjSQL_SMP_VDJ_JOB_PER_TARGET_update_finish_time@/VdjSQL_SMP_VDJ_JOB_PER_TARGET_update_occur_timeA*VdjSQL_CountGivenId_SMP_VDJ_JOB_PER_TARGETB0VdjSQL_CountGivenIdActive_SMP_VDJ_JOB_PER_TARGETC8VdjSQL_Retrieve_SMP_VDJ_JOB_PER_TARGET_info_with_rowlockD VdjSQL_DeleteAllActiveJobsOnNodeE VdjSQL_Insert_SMP_VDJ_JOB_TARGETF VdjSQL_Delete_SMP_VDJ_JOB_TARGETGVdjSQL_DeleteJobAgainstTargetsH#VdjSQL_DeleteJob_SMP_VDJ_JOB_TARGETI&VdjSQL_CountGivenId_SMP_VDJ_JOB_TARGETJ%VdjSQL_RetrieveJob_SMP_VDJ_JOB_TARGETKVdjSQL_Check_SMP_VDJ_JOB_LOGLVdjSQL_Insert_SMP_VDJ_JOB_LOGM+VdjSQL_Insert_SMP_VDJ_JOB_LOG_LatestExecNumN removeJobLogsOVdjSQL_Delete_SMP_VDJ_JOB_LOGP"VdjSQL_Delete_SMP_VDJ_JOB_LOG_listQVdjSQL_Truncate_SMP_VDJ_JOB_LOGR&VdjSQL_MarkForDeletion_SMP_VDJ_JOB_LOGS#VdjSQL_DeleteMarked_SMP_VDJ_JOB_LOGTVdjSQL_Retrieve_SMP_VDJ_JOB_LOGU$retrieve_SMP_VDJ_JOB_LOG_statusIndex'retrieve_SMP_VDJ_JOB_LOG_timeStampIndex&retrieve_SMP_VDJ_JOB_LOG_timeZoneIndex&retrieve_SMP_VDJ_JOB_LOG_outputIdIndex-VdjSQL_Retrieve_SMP_VDJ_JOB_LOG_for_timestampV4retrieve_SMP_VDJ_JOB_LOG_for_timestamp_outputIdIndexVdjSQL_jobHistorySelectForUserW#VdjSQL_jobHistorySelectForSuperUserXVdjSQL_getJobHistoryY$VdjSQL_getJobHistoryWithoutStartInfoZVdjSQL_getJobProgress[VdjSQL_getJobStartInfo\getJobStartInfo_timeZoneIndexgetJobStartInfo_timeStampIndexgetJobStartInfo_execNumIndex#VdjSQL_CountGivenId_SMP_VDJ_JOB_LOG]'VdjSQL_CountGivenIdList_SMP_VDJ_JOB_LOG^VdjSQL_ActiveJobsOnTarget_ VdjSQL_Insert_SMP_VDJ_JOB_OUTPUT`(VdjSQL_Insert_SMP_VDJ_JOB_OUTPUT_Initiala VdjSQL_Delete_SMP_VDJ_JOB_OUTPUTb"VdjSQL_Truncate_SMP_VDJ_JOB_OUTPUTc"VdjSQL_Retrieve_SMP_VDJ_JOB_OUTPUTd'retrieve_SMP_VDJ_JOB_OUTPUT_lengthIndex%retrieve_SMP_VDJ_JOB_OUTPUT_dataIndexVdjSQL_ReassignObjecteVdjSQL_NextJobIDfVdjSQL_NextBlobIDgVdjSQL_AgentTimeZoneh()VCodeLineNumberTable SourceFile VdjSQL.java oracle/sysman/vdj/VdjSQLjava/lang/ObjectINSERT into SMP_VDJ_JOB (job_id, job_name, owner, description, app_name, target_type, schedule, submit_time, is_fixit, is_lib, last_mod_by, last_mod_time, time_zone, incomplete, overriding_node_creds ) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)DELETE from SMP_VDJ_JOB job WHERE job.job_id = ? AND job.job_id not in (select distinct job_id from smp_vdj_job_log) kSELECT job_name, owner FROM SMP_VDJ_JOB WHERE job_id = ? FOR UPDATEUPDATE SMP_VDJ_JOB set owner = ?, description = ?, last_mod_by = ?, last_mod_time = ?, time_zone = ? WHERE job_id = ? fUPDATE SMP_VDJ_JOB set job_name = ?, owner = ?, description = ?, target_type = ?, schedule = ?, is_fixit = ?, last_mod_by = ?, last_mod_time = ?, time_zone = ?, incomplete = ?, overriding_node_creds = ? WHERE job_id = ? SELECT time_zone, job_name, owner, NVL(description, ' ') "description", app_name, target_type, schedule, submit_time, is_fixit, is_lib, last_mod_by, last_mod_time, incomplete, overriding_node_creds from SMP_VDJ_JOB WHERE job_id = ? SELECT t.target_name "TARGET_NAME", t.target_type "TARGET_TYPE", t.node_name "NODE_NAME" FROM SMP_VDJ_JOB_PER_TARGET t, SMP_VDJ_JOB j WHERE ( t.job_id = j.job_id ) AND ( j.job_id = ? ) AND ( j.is_fixit = ? ) AND ( t.status NOT IN ( 14, 1, 13, 15 )) SELECT target_type, schedule, is_fixit, overriding_node_creds from SMP_VDJ_JOB WHERE job_id = ? cSELECT time_zone, submit_time, last_mod_time from SMP_VDJ_JOB WHERE job_id = ? gSELECT job_id from SMP_VDJ_JOB WHERE lower(job_name) = ? and lower(owner) = ? gSELECT job_name, owner, is_fixit from SMP_VDJ_JOB WHERE job_id = ? FSELECT job_id from SMP_VDJ_JOB WHERE owner = ? xSELECT job_id, job_name, job_id, is_lib from SMP_VDJ_JOB WHERE owner = ? iSELECT job_id, job_name, owner from SMP_VDJ_JOB WHERE is_lib = 1 SELECT job_id, job_name, owner FROM SMP_VDJ_JOB WHERE job_id IN (%s) AND is_fixit = 1 aselect all_jobs.job_id "JOB_ID", all_jobs.job_name "JOB_NAME", all_jobs.owner "OWNER" FROM %s all_jobs WHERE is_fixit = 1 AND is_lib = 0 AND (%s) AND lower(target_type) = lower(?) AND (%s = (select count(*) from SMP_VDJ_JOB_PER_TARGET JT where JT.job_id = all_jobs.job_id AND JT.status NOT IN (14,1,13,15) AND (%s))) JT.target_nameySELECT job_id, job_name, owner from SMP_VDJ_JOB WHERE is_lib = 1 and owner = ? wSELECT job_id from SMP_VDJ_JOB WHERE is_lib = 1 and lower(job_name) = ? and lower(owner) = ? SELECT job_name, Owner, NVL(description, ' ') "description", job_id from %s WHERE is_lib = 1 AND (%s) job_idSELECT job_name, Owner, job_id from SMP_VDJ_JOB WHERE is_lib = 0 AND SELECT job_name, Owner, job_id from SMP_VDJ_JOB WHERE is_lib = 0 7SELECT is_lib from SMP_VDJ_JOB WHERE job_id = ? CSELECT target_type from SMP_VDJ_JOB WHERE job_id = ? -LOCK TABLE SMP_VDJ_JOB_LOCK IN EXCLUSIVE MODEW begin ? := SMP_VDJ.insertJob(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); end; 7begin SMP_VDJ.insertNotifications(?,?,?,?,?,?,?); end; @ update SMP_VDJ_JOB set OVERRIDING_NODE_CREDS = ? where job_id=?INSERT into SMP_VDJ_JOB_PER_TARGET (job_id, target_name, job_name, target_type, node_name, exec_num, occur_time, time_zone, status) values (?, ?, ?, ?, ?, 0, ?, ?, 1)update SMP_VDJ_JOB_PER_TARGET set occur_time = SYSDATE, exec_num = exec_num + 1, time_zone = ?, status = 1 where job_id = ? and %s select target_name, target_type, node_name from SMP_VDJ_JOB_PER_TARGET where job_id = ? and %s and ( status = 15 or status = 14 ) `SELECT time_zone, job_name, target_name, node_name, target_type, deliver_time, exec_num, start_time, finish_time, next_exec_time, occur_time, status from SMP_VDJ_JOB_PER_TARGET WHERE job_id = ? and target_name = ? SELECT time_zone, job_name, target_name, node_name, target_type, deliver_time, exec_num, start_time, finish_time, next_exec_time, occur_time, status from SMP_VDJ_JOB_PER_TARGET WHERE job_id = ? and target_name = ? and status != 14 AND status != 15~SELECT job_id, target_name, target_type from SMP_VDJ_JOB_PER_TARGET where node_name = ? AND status != 14 AND status != 15aDELETE from SMP_VDJ_JOB_PER_TARGET WHERE job_id = ? and target_name = ? KDELETE from SMP_VDJ_JOB_PER_TARGET WHERE job_id = ?DELETE from SMP_VDJ_JOB_PER_TARGET WHERE ( status = 15 or status = 14 ) AND (job_id, target_name) not in (select distinct job_id, target_name from smp_vdj_job_log) +begin SMP_VDJ.removeAllJobLogs(?,?,?); end;4begin SMP_VDJ.processClearHistoryAfterTrunc(?); end;3begin SMP_VDJ.processClearHistoryAfterMark(?); end;iSELECT status, target_name, node_name from SMP_VDJ_JOB_PER_TARGET WHERE job_id = ? zSELECT status, target_name, node_name from SMP_VDJ_JOB_PER_TARGET WHERE job_id = ? AND status != 14SELECT status, node_name, target_type from SMP_VDJ_JOB_PER_TARGET WHERE job_id = ? and target_name = ? tSELECT AllJobs.job_id "job_id", status, target_name from SMP_VDJ_JOB_PER_TARGET AllJobs, SMP_VDJ_JOB JobList WHERE lower(JobList.owner) = ? and JobList.job_id = AllJobs.job_id and lower(AllJobs.job_name) = ? and JobList.target_type = ? and AllJobs.target_name in (%s) and AllJobs.status != 15 and AllJobs.status != 145SELECT AllJobs.job_id "job_id", status, target_name from SMP_VDJ_JOB_PER_TARGET AllJobs, SMP_VDJ_JOB JobList WHERE lower(JobList.owner) = ? and JobList.job_id = AllJobs.job_id and lower(AllJobs.job_name) = ? and AllJobs.status != 15 and AllJobs.status != 14upper(principal_name)=upper(?)1=1 SMP_VDJ_JOBSMP_VIEW_VDJ_PRIV_JOBSELECT AllJobs.job_name "JOB_NAME", AllJobs.target_name, AllJobs.target_type "TARGET_TYPE", JobList.owner "OWNER", decode( status, 2, decode( JobList.is_fixit, 1,3, status ), 4, decode( JobList.is_fixit, 1,5, status ), 6, decode( JobList.is_fixit, 1,7, status ), 9, decode( JobList.is_fixit, 1,10, status ), 11, decode( JobList.is_fixit, 1,12, status ), 18, decode( JobList.is_fixit, 1,19, status ), 20, decode( JobList.is_fixit, 1,21, status ), 22, decode( JobList.is_fixit, 1,23, status ), status ) "STATUS", exec_num, start_time, decode( status, 1, to_date(NULL), 2, decode( JobList.is_fixit, 1, to_date(NULL), next_exec_time ), 13, to_date(NULL), 4, start_time, 18, finish_time, 20, finish_time, 22, finish_time, next_exec_time ) "TIME_STAMP", AllJobs.job_id "JOB_ID", AllJobs.time_zone "TIME_ZONE", JobList.is_fixit "IS_FIXIT" FROM SMP_VDJ_JOB_PER_TARGET AllJobs, %s JobList WHERE AllJobs.job_id = JobList.job_id AND AllJobs.status != 15 AND AllJobs.status != 14 AND (%s) ORDER BY AllJobs.occur_time descW SELECT unique JobList.job_name "JOB_NAME", JobList.target_type "TARGET_TYPE", JobList.owner "OWNER", JobList.job_id "JOB_ID" FROM SMP_VDJ_JOB_PER_TARGET AllJobs, %s JobList WHERE AllJobs.job_id = JobList.job_id AND AllJobs.status != 15 AND AllJobs.status != 14 AND (%s) SELECT COUNT(*) FROM smp_vdj_job_log WHERE job_id = ? 3SELECT COUNT(*) FROM smp_vdj_job_log WHERE SELECT JOB_NAME, OWNER FROM SMP_VDJ_JOB WHERE IS_LIB = 0 AND JOB_ID IN (SELECT JOB_ID FROM SMP_VDJ_JOB_PER_TARGET WHERE TARGET_TYPE = ? AND TARGET_NAME = ? AND STATUS IN (1,4,2,13,9,11,18,20,22,8))kINSERT into SMP_VDJ_JOB_OUTPUT (blob_id, length, data) values (?, ?, ?)lINSERT into SMP_VDJ_JOB_OUTPUT (blob_id, length, data) values (0, 0, '')DDELETE from SMP_VDJ_JOB_OUTPUT WHERE blob_id = ? # TRUNCATE table SMP_VDJ_JOB_OUTPUT gSELECT length, data from SMP_VDJ_JOB_OUTPUT WHERE blob_id = ? 8UPDATE SMP_VDJ_JOB SET owner = upper(?) WHERE job_id = ?+SELECT SMP_VDJ_JOB_ID_SEQ.nextval from dual/SELECT SMP_VDJ_JOB_OUTPUT_SEQ.nextval from dualh SELECT /*+ FIRST_ROWS */ DISTINCT TIME_ZONE FROM SMP_VDJ_JOB_LOG WHERE TARGET_NAME = ? AND STATUS = 91      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~*