Edit D:\app\Administrator\product\11.2.0\dbhome_1\jlib\oracle\sysman\vdj\VdjSQL.class
?? /i VdjSQL_Insert_SMP_VDJ_JOB Ljava/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_timeZoneIndex I !retrieve_SMP_VDJ_JOB_jobNameIndex retrieve_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_JobInfoForSubmit VdjSQL_Retrieve_Times retrieve_Times_timeZoneIndex retrieve_Times_submitTimeIndex retrieve_Times_lastModTimeIndex VdjSQL_JobID_Given_NameAndOwner VdjSQL_JobInfo_Given_JobID VdjSQL_JobIDs_Given_Owner VdjSQL_Jobs_Given_Owner VdjSQL_Get_All_Job_Libs VdjSQL_Get_All_Fixit_Jobs VdjSQL_Get_Distinct_Fixit_Jobs +VdjSQL_Get_Distinct_Fixit_Jobs_JTTargetName /get_Distinct_Fixit_Jobs_with_Targets_jobIdIndex 1get_Distinct_Fixit_Jobs_with_Targets_jobNameIndex /get_Distinct_Fixit_Jobs_with_Targets_ownerIndex VdjSQL_Get_Job_Libs_Of_Owner %VdjSQL_Get_Job_Libs_Of_Owner_and_Name )get_Job_Libs_Of_Owner_and_Name_jobIdIndex VdjSQL_getJobLibResultSet VdjSQL_job_id_Cname VdjSQL_getSubmittedJobList VdjSQL_getAllSubmittedJobs VdjSQL_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_targetsWithoutAgentsIndex VdjSQL_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_processClearHistoryTrunc0 VdjSQL_processClearHistoryMark1 +VdjSQL_Retrieve_SMP_VDJ_JOB_PER_TARGET_info2 1VdjSQL_RetrieveActive_SMP_VDJ_JOB_PER_TARGET_info3 0retrieve_SMP_VDJ_JOB_PER_TARGET_info_statusIndex 4retrieve_SMP_VDJ_JOB_PER_TARGET_info_targetNameIndex 2retrieve_SMP_VDJ_JOB_PER_TARGET_info_nodeNameIndex 7VdjSQL_Retrieve_SMP_VDJ_JOB_PER_TARGET_info_with_target4 1VdjSQL_Retrieve_SMP_VDJ_JOB_PER_TARGET_active_job5 VdjSQL_RetrieveOwnedActiveJobs6 VdjSQL_CrsUserClause7 VdjSQL_CrsSuperUserClause8 VdjSQL_jobs_suTable9 VdjSQL_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_TARGETB 0VdjSQL_CountGivenIdActive_SMP_VDJ_JOB_PER_TARGETC 8VdjSQL_Retrieve_SMP_VDJ_JOB_PER_TARGET_info_with_rowlockD VdjSQL_DeleteAllActiveJobsOnNodeE VdjSQL_Insert_SMP_VDJ_JOB_TARGETF VdjSQL_Delete_SMP_VDJ_JOB_TARGETG VdjSQL_DeleteJobAgainstTargetsH #VdjSQL_DeleteJob_SMP_VDJ_JOB_TARGETI &VdjSQL_CountGivenId_SMP_VDJ_JOB_TARGETJ %VdjSQL_RetrieveJob_SMP_VDJ_JOB_TARGETK VdjSQL_Check_SMP_VDJ_JOB_LOGL VdjSQL_Insert_SMP_VDJ_JOB_LOGM +VdjSQL_Insert_SMP_VDJ_JOB_LOG_LatestExecNumN removeJobLogsO VdjSQL_Delete_SMP_VDJ_JOB_LOGP "VdjSQL_Delete_SMP_VDJ_JOB_LOG_listQ VdjSQL_Truncate_SMP_VDJ_JOB_LOGR &VdjSQL_MarkForDeletion_SMP_VDJ_JOB_LOGS #VdjSQL_DeleteMarked_SMP_VDJ_JOB_LOGT VdjSQL_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_timestampV 4retrieve_SMP_VDJ_JOB_LOG_for_timestamp_outputIdIndex VdjSQL_jobHistorySelectForUserW #VdjSQL_jobHistorySelectForSuperUserX VdjSQL_getJobHistoryY $VdjSQL_getJobHistoryWithoutStartInfoZ VdjSQL_getJobProgress[ VdjSQL_getJobStartInfo\ getJobStartInfo_timeZoneIndex getJobStartInfo_timeStampIndex getJobStartInfo_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_dataIndex VdjSQL_ReassignObjecte VdjSQL_NextJobIDf VdjSQL_NextBlobIDg VdjSQL_AgentTimeZoneh <init> ()V Code LineNumberTable SourceFile VdjSQL.java oracle/sysman/vdj/VdjSQL java/lang/Object?NSERT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ?ELETE 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 UPDATE ?PDATE 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 = ? ?ELECT 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 )) ?ELECT 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 ?ELECT 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_name ySELECT 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) = ? ?ELECT job_name, Owner, NVL(description, ' ') "description", job_id from %s WHERE is_lib = 1 AND (%s) job_id ?ELECT job_name, Owner, job_id from SMP_VDJ_JOB WHERE is_lib = 0 AND ?ELECT 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 MODE W begin ? := SMP_VDJ.insertJob(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); end; 7begin SMP_VDJ.insertNotifications(?,?,?,?,?,?,?); end; @ update SMP_VDJ_JOB set OVERRIDING_NODE_CREDS = ? where job_id=? ?NSERT 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) ?pdate SMP_VDJ_JOB_PER_TARGET set occur_time = SYSDATE, exec_num = exec_num + 1, time_zone = ?, status = 1 where job_id = ? and %s ?elect 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 = ? ?ELECT 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 != 15 aDELETE from SMP_VDJ_JOB_PER_TARGET WHERE job_id = ? and target_name = ? KDELETE from SMP_VDJ_JOB_PER_TARGET WHERE job_id = ? ?ELETE 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 != 14 SELECT 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 != 14 upper(principal_name)=upper(?) 1=1 SMP_VDJ_JOB SMP_VIEW_VDJ_PRIV_JOB?ELECT 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) <DELETE from SMP_VDJ_JOB_PER_TARGET WHERE job_id = ? ?PDATE SMP_VDJ_JOB_PER_TARGET set exec_num = exec_num + 1, next_exec_time = ?, time_zone = ?, status = ? WHERE job_id = ? and target_name = ? ?PDATE SMP_VDJ_JOB_PER_TARGET set start_time = ?, time_zone = ?, status = ? WHERE job_id = ? and target_name = ? ?PDATE SMP_VDJ_JOB_PER_TARGET set finish_time = ?, time_zone = ?, status = ? WHERE job_id = ? and target_name = ? ?PDATE SMP_VDJ_JOB_PER_TARGET set occur_time = ?, time_zone = ?, status = ? WHERE job_id = ? and target_name = ? ESELECT COUNT(*) from SMP_VDJ_JOB_PER_TARGET WHERE job_id = ? gSELECT COUNT(*) from SMP_VDJ_JOB_PER_TARGET WHERE job_id = ? AND status != 14 AND status != 15 ?ELECT status, node_name, exec_num, target_type from SMP_VDJ_JOB_PER_TARGET WHERE job_id = ? and target_name = ? FOR UPDATE vUPDATE SMP_VDJ_JOB_PER_TARGET set STATUS = 14 where NODE_NAME = ? AND STATUS != 14 AND STATUS != 15 hINSERT into SMP_VDJ_JOB_TARGET (job_id, target_name, target_type) values (?, ?, ?) sDELETE from SMP_VDJ_JOB_TARGET WHERE job_id = ? and job_name = ? and target_type = ? W begin SMP_VDJ.deleteJobsAgainstTargets( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ); end; 8DELETE from SMP_VDJ_JOB_TARGET WHERE job_id = ? ASELECT COUNT(*) from SMP_VDJ_JOB_TARGET WHERE job_id = ? MSELECT target_name, target_type from SMP_VDJ_JOB_TARGET WHERE job_id = ? ?ELECT job_id, target_name, time_stamp, time_zone, status FROM SMP_VDJ_JOB_LOG WHERE job_id = ? AND target_name = ? AND time_stamp = ? AND time_zone = ? AND status = ? ?NSERT into SMP_VDJ_JOB_LOG (job_id, target_name, exec_num, status, time_stamp, time_zone, output_id) values (?, ?, ?, ?, ?, ?, ?)?NSERT into SMP_VDJ_JOB_LOG (job_id, target_name, exec_num, status, time_stamp, time_zone, output_id) (select ?, ?, decode(max(Log.exec_num), null, 1, max(Log.exec_num)), ?, ?, ?, ? from SMP_VDJ_JOB_LOG Log, SMP_VDJ_JOB Job where Job.job_id=Log.job_id and Log.job_id = ? and Log.target_name = ? and Job.target_type = ?) 3begin ? := SMP_VDJ.removeJobLogs(?,?,?,?,?,?); end; tDELETE from SMP_VDJ_JOB_LOG WHERE job_id = ? and target_name = ? and exec_num = ? /DELETE from SMP_VDJ_JOB_LOG WHERE TRUNCATE table SMP_VDJ_JOB_LOG .UPDATE SMP_VDJ_JOB_LOG SET status= 17 WHERE @DELETE from SMP_VDJ_JOB_LOG where status= 17 AND ROWNUM <= ? ?ELECT status, time_stamp, time_zone, output_id from SMP_VDJ_JOB_LOG WHERE job_id = ? and target_name = ? and exec_num = ? and ( status = 11 or status = 9 ) ?ELECT output_id from SMP_VDJ_JOB_LOG WHERE job_id = ? and target_name = ? and exec_num = ? and time_stamp = ? and time_zone = ? and status = ? SELECT SELECT /*+ ALL_ROWS */ 3JobLogEnd.time_zone, Job.job_name, JobLogEnd.target_name, Job.target_type "TARGET_TYPE", Job.owner, decode( JobLogEnd.status, 9, decode( Job.is_fixit, 1,10, JobLogEnd.status ), 11, decode( Job.is_fixit, 1,12, JobLogEnd.status ), 18, decode( Job.is_fixit, 1,19, JobLogEnd.status ), 20, decode( Job.is_fixit, 1,21, JobLogEnd.status ), 22, decode( Job.is_fixit, 1,23, JobLogEnd.status ), JobLogEnd.status ) "STATUS", JobLogStart.time_stamp "START_TIME", JobLogEnd.time_stamp "FINISH_TIME", JobLogEnd.job_id, JobLogEnd.exec_num, JobLogEnd.output_id FROM SMP_VDJ_JOB_LOG JobLogStart, %s Job, SMP_VDJ_JOB_LOG JobLogEnd WHERE JobLogEnd.status in ( 9 , 18 , 20 , 22 , 11) AND JobLogStart.status = 4 AND Job.job_id = JobLogEnd.job_id AND JobLogStart.job_id = JobLogEnd.Job_id AND JobLogStart.target_name = JobLogEnd.target_name AND JobLogStart.exec_num = JobLogEnd.exec_num AND (%s) ORDER BY JobLogEnd.time_stamp desc ?obLogEnd.time_zone, Job.job_name, JobLogEnd.target_name, Job.target_type "TARGET_TYPE", Job.owner, decode( JobLogEnd.status, 9, decode( Job.is_fixit, 1,10, JobLogEnd.status ), 11, decode( Job.is_fixit, 1,12, JobLogEnd.status ), 18, decode( Job.is_fixit, 1,19, JobLogEnd.status ), 20, decode( Job.is_fixit, 1,21, JobLogEnd.status ), 22, decode( Job.is_fixit, 1,23, JobLogEnd.status ), JobLogEnd.status ) "STATUS", JobLogEnd.time_stamp "FINISH_TIME", JobLogEnd.job_id, JobLogEnd.exec_num, JobLogEnd.output_id FROM %s Job, SMP_VDJ_JOB_LOG JobLogEnd WHERE JobLogEnd.status in ( 9 , 18 , 20 , 22 , 11) AND Job.job_id = JobLogEnd.job_id AND (%s) ORDER BY JobLogEnd.time_stamp desc ?SELECT Log.time_zone, decode( Log.status, 2, decode( Job.is_fixit, 1,3, Log.status ), 4, decode( Job.is_fixit, 1,5, Log.status ), 6, decode( Job.is_fixit, 1,7, Log.status ), 9, decode( Job.is_fixit, 1,10, Log.status ), 11, decode( Job.is_fixit, 1,12, Log.status ), 18, decode( Job.is_fixit, 1,19, Log.status ), 20, decode( Job.is_fixit, 1,21, Log.status ), 22, decode( Job.is_fixit, 1,23, Log.status ), Log.status ) "STATUS", Log.target_name, decode( Log.status, 1, to_date(NULL), 2, decode( Job.is_fixit, 1, to_date(NULL), Log.time_stamp ), Log.time_stamp ) "TIME_STAMP", Log.output_id FROM smp_vdj_job_log Log, smp_vdj_job Job WHERE Log.job_id = %s AND Log.target_name like('%s') AND Log.exec_num like ('%s') AND Log.job_id = Job.job_id AND Log.status != 17 ORDER BY Log.time_stamp desc, Log.status desc?ELECT time_zone, time_stamp, exec_num FROM smp_vdj_job_log log WHERE log.job_id = ? AND log.target_name like (?) AND log.status in ( 4 , 18 , 20 , 22) order by time_stamp >SELECT COUNT(*) FROM smp_vdj_job_log WHERE job_id = ? 3SELECT COUNT(*) FROM smp_vdj_job_log WHERE ?ELECT 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 dual h SELECT /*+ FIRST_ROWS */ DISTINCT TIME_ZONE FROM SMP_VDJ_JOB_LOG WHERE TARGET_NAME = ? AND STATUS = 9 1 ? ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? *? ? ?
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de