Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Manjeet Kalsi" <manjeet dot kalsi at prudential dot com>
Subject: RE: Perl thru crontab
Date: Feb 1 2000 5:20PM

Thanks for all your inputs. It worked.

One more Question. Is there a way to plot a graph using Sybperl, e.g. to show
the rate of growth of database, etc.

Any pointers would be appreciated.



"Bulah, Fred" 
Tuesday February 1, 2000 10:38 AM

Please respond to
To:   SybPerl Discussion List 
cc:    (bcc: Manjeet Kalsi/O&S/Prudential)
Subject:  RE: Perl thru crontab

You don't have to set up a separate shell script to get environment
variables set, but you do have to run in a sub-shell with them set.
Here's a sample line from one of my cron jobs:

0       7       *       *       1-5     /bin/ksh "(.
/home/fbulah/ ; cd ./prod/bin ;
/home/fbulah/prod/bin/ -elocalprod
>>/home/fbulah/prod/logs/spa_get_symbols.log 2>&1)"

You set up a .profile with the necessary environment variables, aliases,
etc.  You kick off the perl script from a shell that executes the profile
prior to running your script.

> -----Original Message-----
> From:   Miao, Qian (PME) []
> Sent:   Tuesday, February 01, 2000 10:10 AM
> To:     SybPerl Discussion List
> Subject:     RE: Perl thru crontab
> cron job doesn't take environment variables that you set for your command
> shell environment.
> you can write a shell script to setup all necessary environment variables
> first, then call your Perl script.
> Instead of running Perl script directly from crontab, you run this shell
> script. this way you don't have to
> get your SA involved in set up  default cron variables.
> > -----Original Message-----
> > From: Manjeet Kalsi []
> > Sent: Tuesday, February 01, 2000 9:18 AM
> > To:   SybPerl Discussion List
> > Subject:   Perl thru crontab
> >
> >
> >
> >
> > Gurus,
> >
> > I am trying to run one of my programs as cron job and I get the
> following
> > error.
> >  Any ideas?
> > Program runs fine from command line.
> >
> >
> >
> > Can't load
> >
> '/usr/local/lib/perl5/site_perl/ultra-solaris/auto/Sybase/CTlib/'
> > for
> > module
> > Sybase::CTlib: /usr/local/bin/perl: fatal: open
> failed:
> > No
> > such file or directory
> > at /usr/local/lib/perl5/ line 140.
> >
> >  at /usr/local/lib/perl5/site_perl/Sybase/ line 845
> > BEGIN failed--compilation aborted at /home/x098919/DBA/ line
> 18.
> >
> >
> >
> >
> > Manjeet
> >

This message is for the named person's use only.  It may contain
confidential, proprietary or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. CREDIT SUISSE GROUP and each of its subsidiaries each reserve
the right to monitor all e-mail communications through its networks.  Any
views expressed in this message are those of the individual sender, except
where the message states otherwise and the sender is authorised to state
them to be the views of any such entity.