REM drv: Rem Rem $Header: paf_jobstep_register.sql 17-jul-2007.01:23:56 rahgupta Exp $ Rem Rem paf_jobstep_register.sql Rem Rem Copyright (c) 2005, 2007, Oracle. All rights reserved. Rem Rem NAME Rem paf_jobstep_register.sql - Rem Rem DESCRIPTION Rem Rem Rem NOTES Rem Rem Rem MODIFIED (MM/DD/YY) Rem rahgupta 07/17/07 - call paf_filetransfer_register_10204 Rem ktamtoro 01/09/06 - XbranchMerge Rem ktamtoro_ui_bugs_4925024_4925037_4927434 from Rem main Rem fantic 12/13/05 - XbranchMerge fantic_jobs_junits_051204 from main Rem zsamar 12/05/05 - XbranchMerge zsamar_bug-4746852 from main Rem ktamtoro 01/09/06 - XbranchMerge Rem ktamtoro_ui_bugs_4925024_4925037_4927434 from Rem main Rem fantic 12/13/05 - XbranchMerge fantic_jobs_junits_051204 from main Rem zsamar 12/05/05 - XbranchMerge zsamar_bug-4746852 from main Rem ktamtoro 01/05/06 - Add display name to file transfer job parameters Rem fantic 12/06/05 - additional params for file transfer: Rem source_file_list, archive_filename Rem zsamar 11/23/05 - Bug 4746852 Rem zsamar 11/23/05 - Bug 4746852 Rem fantic 11/15/05 - changing params for PAFFileTransfer Rem fantic 11/03/05 - seting default values for paf file transfer Rem parameters Rem fantic 10/13/05 - simplify parameters for PAFFileTransfer Rem ktamtoro 09/12/05 - Remove unnecessary param values Rem fantic 09/06/05 - fantic_paf_jobs_050905 Rem fantic 09/06/05 - Created Rem DECLARE l_jobtype_guid VARCHAR2(32); l_group_source_guid VARCHAR2(32); l_group_archive_guid VARCHAR2(32); l_group_dest_guid VARCHAR2(32); BEGIN --register PAFFileTransfer job and parameters MGMT_PAF_UTL.REGISTER_JOBTYPE( p_jobtype => 'PAFFileTransfer', p_description => 'PAF_JOB_FILE_TRANSFER_DESCRIPTION@oracle.sysman.pp.paf.ui.resource.PAResourceBundle', p_target_list_dependent => 'N', x_guid => l_jobtype_guid ); -- register SOURCE group MGMT_PAF_UTL.REGISTER_JOBTYPE_PARAM_GROUP( p_jobtype_guid => l_jobtype_guid, p_name => 'PA_FILE_TRANSFER_SOURCE_HDR@oracle.sysman.pp.paf.ui.resource.PAResourceBundle', p_group_order => 1, x_guid => l_group_source_guid ); -- register ARCHIVE group MGMT_PAF_UTL.REGISTER_JOBTYPE_PARAM_GROUP( p_jobtype_guid => l_jobtype_guid, p_name => 'PA_FILE_TRANSFER_ARCHIVE_HDR@oracle.sysman.pp.paf.ui.resource.PAResourceBundle', p_group_order => 2, x_guid => l_group_archive_guid ); -- register DESTINATION group MGMT_PAF_UTL.REGISTER_JOBTYPE_PARAM_GROUP( p_jobtype_guid => l_jobtype_guid, p_name => 'PA_FILE_TRANSFER_DESTINATION_HDR@oracle.sysman.pp.paf.ui.resource.PAResourceBundle', p_group_order => 3, x_guid => l_group_dest_guid ); -- register parameters for SOURCE MGMT_PAF_UTL.REGISTER_JOBTYPE_PARAM( p_guid => l_jobtype_guid, p_name => 'PA_SOURCE_TARGET_INPUT_PROMPT@oracle.sysman.pp.paf.ui.resource.PAResourceBundle', p_param_name => 'source_target_name', p_order => 1, p_group_guid => l_group_source_guid, p_target_type => 'host' ); MGMT_PAF_UTL.REGISTER_JOBTYPE_PARAM( p_guid => l_jobtype_guid, p_name => 'PA_SOURCE_DIR_INPUT_PROMPT@oracle.sysman.pp.paf.ui.resource.PAResourceBundle', p_param_name => 'source_directory', p_order => 2, p_group_guid => l_group_source_guid ); MGMT_PAF_UTL.REGISTER_JOBTYPE_PARAM( p_guid => l_jobtype_guid, p_name => 'PA_SOURCE_FILE_LIST_INPUT_PROMPT@oracle.sysman.pp.paf.ui.resource.PAResourceBundle', p_param_name => 'source_file_list', p_param_value => '*', p_order => 3, p_group_guid => l_group_source_guid ); MGMT_PAF_UTL.REGISTER_JOBTYPE_PARAM( p_guid => l_jobtype_guid, p_name => 'PA_ARCHIVE_COMMAND_INPUT_PROMPT@oracle.sysman.pp.paf.ui.resource.PAResourceBundle', p_param_name => 'archive_command', p_param_value => '%emd_root%/bin/zip -r', p_order => 4, p_group_guid => l_group_archive_guid ); MGMT_PAF_UTL.REGISTER_JOBTYPE_PARAM( p_guid => l_jobtype_guid, p_name => 'PA_ARCHIVE_FILENAME_INPUT_PROMPT@oracle.sysman.pp.paf.ui.resource.PAResourceBundle', p_param_name => 'archive_filename', p_param_value => 'archive.zip', p_order => 5, p_group_guid => l_group_archive_guid ); MGMT_PAF_UTL.REGISTER_JOBTYPE_PARAM( p_guid => l_jobtype_guid, p_name => 'PA_DEST_TARGET_INPUT_PROMPT@oracle.sysman.pp.paf.ui.resource.PAResourceBundle', p_param_name => 'dest_target_name', p_order => 6, p_group_guid => l_group_dest_guid, p_target_type => 'host' ); MGMT_PAF_UTL.REGISTER_JOBTYPE_PARAM( p_guid => l_jobtype_guid, p_name => 'PA_DEST_DIR_INPUT_PROMPT@oracle.sysman.pp.paf.ui.resource.PAResourceBundle', p_param_name => 'destination_directory', p_order => 7, p_group_guid => l_group_dest_guid ); MGMT_PAF_UTL.REGISTER_JOBTYPE_PARAM( p_guid => l_jobtype_guid, p_name => 'PA_RESTORE_COMMAND_INPUT_PROMPT@oracle.sysman.pp.paf.ui.resource.PAResourceBundle', p_param_name => 'restore_command', p_param_value => '%emd_root%/bin/unzip -o', p_order => 8, p_group_guid => l_group_dest_guid ); COMMIT; END; / @&EM_SQL_ROOT/pp/latest/paf/paf_filetransfer_register_102040.sql