OFFICE






ETL activation and deactivation

Select job,what,broken from user_jobs where what like '%HR_REFRESH%'
-- Disabling Mview refresh
              Begin
                Dbms_job.broken(83405,True);
              End;
               /
              Commit
               /

Select job,what,broken from user_jobs where job = 83405;
-- Enabling Mview refresh
           Begin
                Dbms_job.broken(83405,False);
              End;
               /
              Commit
               /

Decryption of files


Maytas activity we do.




bwp10460001
sftp://dyl03839app01.nat.bt.com
ftp:\\psoft1:pas27btm@dyl03839app01.nat.bt.com\inuit\nas\temp\choices

/inuit/nas/temp/choices
\inuit\nas\temp\choices
Winzip pwd : trainee123

It is HUB to send and receive messages from and to PeopleSoft environments BTPS HR8 to vebnet (choices) and from eOrg ouc service9 How to know windows server version? Mycomputer-->right click --> goto--> properties. desc PSPRCSRQST; desc PSPRPSQUEUE; select * from PSPRCSRQST; -- where PRCINSTANCE='157995'; select * from PSPRCSRQST where PRCSINSTANCE='157995'; select * from PSPRCSQUE where PRCSINSTANCE='157995'; how to clear log files. cp /dev/null sqlnet.log Peolesoft log files of batch jobs /apps/psoft/prod/pt851_epm/appserv/prcs/DWPRD01/log_output.