|
|
Archives of the TeradataForum
Message Posted: Wed, 27 Jul 2005 @ 14:42:52 GMT
Subj: | | Re: Using rexec/rsh from Windows client |
|
From: | | Ray, Edmond |
You may want to consider one more tool here. If you run your jobs on Unix with nohup and redirect the output to a log file. You can scan the
log file with some combination of sed, awk, and perl. With this setup you can ignore the issues of network failures etc. I use this type of
architecture for a backup solution I built for our application. The master script runs in nohup and calls other scripts in the process. At the end
of each child script I scan the output log for the results (row counts, status, error messages) and insert them into a table. If any child script
returns an error the master script sends an email to the help desk staff. I retain the logs for 30 days, and as much of the table as there is
space for.
Ed Ray
| |