Archives of the TeradataForum

Message Posted: Fri, 06 Jun 2003 @ 08:07:36 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Friday, June 06, 2003 03:48 -->

Hello there,

I'm used to checking manually the result of scheduled jobs on Unix (SLJM).

In order to automate the checking, I'm looking for finding a way to get the output of the command "j job_name" not on the screen, but in a file.

Actually there is already a file which contains the status of the job (.sched), but unfortunately the date field (the 3rd one) has a null value and is therefore unusable for a serious checking...

20 :Done:0:1054861115:1054861116:/DWH/Scripts/xxx.sql

I tried also a redirection to a file with "j job_name > /../log". It works fine when I run the command manually, but if I run it in a script scheduled in crontab, just an empty file is produced...

Does someone have any experience in the automation of Unix job control? Is there a way to produce automatically the result or status of scheduled jobs in a file (with a valid date of execution !) Thanks to this file I will then been able to let a Perl script interpret it and generate a HTML file which will be consulted on the intranet.

Thanks for your input !

Regards

	<Prev	Next>		<<First	<Prev	Next>	Last>>