06-18-2013
UNIX help with informatica
Guys,
I have a requirement.Please suggest the way i can :
A script is being used to generate a file and send a mail to a source team if the feed for informatica jobs have not reached the server.
If the file has not reached the server,the informatica jobs touch 0 byte file after 3 hours and complete the load.
Now i want to add an additional case :
When the source team sends the file to the server after they receive this mail ,the job shall be triggered automatically.
I have n number of informatica jobs and i cannot specify one just workflow name.
My thoughts:
The script which generate mail , it shall sleep for around 2 hrs and then go to the path where the feed is recieved in the server and check for the files.For example:
the mail contain A file and i got A file in the server. It compares both file and return yes.
Now it will pick the concerned job log from the log path and by pmcmd trigger that job.
Will it be feasible?
Thanks
9 More Discussions You Might Find Interesting
1. UNIX and Linux Applications
hi guys,
I have to ftp an empty text file dim_trigger.txt form 1 server to another. The target server is mtiftp and i have defined the username and password.
Below is the shellscript thats in a file called dim_trigger.ksh
#!/bin/ksh
#
# FTP Bo trigger
#
HOST= 'mtiftp'
USER=... (0 Replies)
Discussion started by: fgene1
0 Replies
2. Shell Programming and Scripting
Hi
I have a shell script which is running fine in unix. But if i call the shell script thro informatica workflow post session command task it is not giving me the sum(amount) to a output text file
The sql_configh.sh file has uid@db/pwd
script_path="/path"
cd $script_path
connstr=`grep... (1 Reply)
Discussion started by: ksmbabu
1 Replies
3. UNIX for Dummies Questions & Answers
hi,
i want to call unix script from transformations used in informatica mapping?
can we do it in any way? Please reply ASAP.
We cant use Storep procedure transformation
Thanks in Advance
nishith (0 Replies)
Discussion started by: Nishithinfy
0 Replies
4. UNIX for Advanced & Expert Users
1.How will you do automation of Informatica jobs using Unix ?
2. How u run workflow from Unix? :) (2 Replies)
Discussion started by: kamesh83
2 Replies
5. Shell Programming and Scripting
Hi Rockers,
I hope u r dng good one. I have a one question is in unix with informatica . I need a unix script to check whether particular file exists in the folder , If it means we have a informatica server , so we can start the informatica server by accessing that file. Every week we have... (0 Replies)
Discussion started by: gurukrishnan
0 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have very little knowledge with unix and pmcmd. I need help with a issue.
I have to see whether a file has been dropped in a particular location/path. If the file dropped I have to check the last modified time, which should be greater than 8pmEST the prior day. If the file has been... (4 Replies)
Discussion started by: redwolves
4 Replies
7. Shell Programming and Scripting
Hi Guys,
I am trying below condition .
We are using Informatica 9.5 and scheduling certain informatica mapping on set timings .But we are not sure whether the database source table are latest or not .Since its gets updated on daily basis and not sure when it completes.Can we write any unix/perl... (1 Reply)
Discussion started by: Perlbaby
1 Replies
8. UNIX for Advanced & Expert Users
HI Team ,
I have interesting issue observed when using teradata sql assistant(14.1) and Informatica tool (9.5) versions.
I created SQL code in teradata where source count is 5000 records . I am using source and target database as teradata and trying to load using informatica tool . Its straight... (0 Replies)
Discussion started by: Perlbaby
0 Replies
9. Shell Programming and Scripting
Hello ,
Can any one provide a code which can take XML input and have the tags in a seperate file.? (5 Replies)
Discussion started by: Si7798
5 Replies
LEARN ABOUT DEBIAN
check_gearman
CHECK_GEARMAN(8) System Administration Utilities CHECK_GEARMAN(8)
NAME
check_gearman - Nagios service check to monitor the gearman job server
DESCRIPTION
usage:
check_gearman [ -H=<hostname>[:port] ]
[ -t=<timeout>
]
[ -w=<jobs warning level>
] default: 10
[ -c=<jobs critical level>
] default: 100
[ -W=<worker warning level>
] default: 25
[ -C=<worker critical level>
] default: 50
[ -q=<queue>
]
to send a test job:
[ -u=<unique job id>
] default: check
[ -s=<send text>
]
[ -e=<expect text>
]
[ -a send async ] will ignore -e
[ -h print help ]
[ -v verbose output ]
[ -V print version ]
- You may set thresholds to 0 to disable them. - Thresholds are only for server checks, worker checks are availability only
perfdata format when checking job server:
|'queue waiting'=current waiting jobs;warn;crit;0 'queue running'=current running jobs 'queue worker'=current num worker;warn;crit;0
Note: set your pnp RRD_STORAGE_TYPE to MULTIPLE to support changeing numbers of queues.
see http://docs.pnp4nagios.org/de/pnp-0.6/tpl_custom for detailed information
perfdata format when checking mod gearman worker:
|worker=10 jobs=1508c
Note: Job thresholds are per queue not totals.
EXAMPLES
Check job server:
%>./check_gearman -H localhost -q host check_gearman OK - 0 jobs running and 0 jobs waiting. Version: 0.14|'host_waiting'=0;10;15;0
'host_running'=0 'host_worker'=3;5;10;0
Check worker:
%> ./check_gearman -H <job server hostname> -q worker_<worker hostname> -t 10 -s check check_gearman OK - host has 5 worker and is working
on 0 jobs|worker=5 jobs=96132c
SEE ALSO
The Mod Gearman documentation is available in /usr/share/doc/mod-gearman/README.html
check_gearman 1.3.6-1 July 2012 CHECK_GEARMAN(8)