Sponsored Content
Top Forums Shell Programming and Scripting Scripts not nunning in CRONTAB Post 302417947 by rsivasan on Saturday 1st of May 2010 03:26:10 PM
Old 05-01-2010
Code:
#!/usr/local/bin/perl
#DB CONNECTION
use Oraperl;
use DBI;
$ENV{"ORACLE_HOME"} = "/oracle/8.1.7";
$sUsername = "s3\@cdb";
$sPassword = "5e";
$hConnection = &ora_login("", $sUsername, $sPassword)
                               or die "\nCould not Connect DATABASE \n ERROR DETAILS \n *************\n $DBI::errstr";
open (OUTFILE, '>/export/home/ravikus/scripts/in.txt');
$ f1= "/export/home/ravikus/scripts/input.txt";
open(f1) or die("Could not open test file.");
foreach $user (<f1>) {
chop($user);
$hQuery = &ora_open($hConnection, "select name from domain where name='$user' and mail_domain='O' and hostname='www'")
 or die "\nWARNING...Check whether the $user Domain IS EXISTS in C2B DB.\n ERROR DETAILS \n *************\n $DBI::errstr";
@asQueryReturn = &ora_fetch($hQuery);
#if($REFCNT != 1)
#{
if(@asQueryReturn != 0)
{
$nme = $asQueryReturn[0];
#$llg = $asQueryReturn[1];
#$cre = $asQueryReturn[2];
#chop($nme);
#chop($sts);
print OUTFILE "$nme \n";
@asQueryReturn = &ora_fetch($hQuery);
}
#else
#{
#print "The $user USER NAME is not found in C2B Database\n";
#}
#}
&ora_close($hQuery);
} #END FOR LOOP
close(OUTFILE);
close(f1);
&ora_logoff($hConnection);


Last edited by DukeNuke2; 05-01-2010 at 04:38 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX Desktop Questions & Answers

audit to crontab scripts

hi, I have scripts which are running every 3 minutes. The scripts include connection to a database, using sqlplus. Sometimes, the connection fails (invalid username or password, locked user etc..) and the connection returns the error code, to the unix screen or to a file. I want whenever there's... (2 Replies)
Discussion started by: krem
2 Replies

2. Shell Programming and Scripting

Crontab PHP scripts not ending

when i run the scripts from command line like php ./file.php they run fine and it ends. But i have them running in crontab every 5 minutes and they sometimes dont close. Can i write something to log why or force them to close after a certain amount of time by killing the pid? (2 Replies)
Discussion started by: nitrous
2 Replies

3. Shell Programming and Scripting

Trigger a script by consequtive scripts in crontab

Hello Friends, I've been searching solutions for an exceptional backup case recently, I need someone to guide me, suggest a method pls. In a production system we have backup scripts, they are run by cron one after another, and monthly. There is 1 hour difference between each consecutive script... (1 Reply)
Discussion started by: EAGL€
1 Replies

4. Debian

Problems with Crontab not executing scripts after edit

Hi all I installed Debian and i have a few scripts that outputs what is happening. The wierd part...after fresh install all works ok but after i open or edit Crontab it stops executing the scripts...and scripts runs manually so its not a problem with scripts...what happens is that i usually... (3 Replies)
Discussion started by: ro0t3d
3 Replies

5. UNIX for Dummies Questions & Answers

Deleted the scripts in Crontab by mistake

hi, instead of typing crontab -e i gave crontab -r and hit enter. So i lost all my scripts. Is there any way to restore the deleted scripts? Please help me out Thanks Ajay (3 Replies)
Discussion started by: ajayakunuri
3 Replies

6. UNIX for Dummies Questions & Answers

Help with Crontab and Scripts

I'm trying to create a crontab that runs every hour and runs a script in my $HOME/bin directory. Everytime it goes to run it I get this mail. Message 14: From root@xx.xxxx.edu Thu Apr 12 14:03:01 2012 Return-Path: <root@xx.xxxx.edu> X-Original-To: bbowers Delivered-To:... (4 Replies)
Discussion started by: bbowers
4 Replies

7. Shell Programming and Scripting

How to get cron (scripts in crontab) started?

Hi, I have a query related to UNIX Crontab scripts - Issue: Server space on the db server got 100% full as a result of which the cron scripts did not run. The space utilization issue got resolved in the afternoon. The crons scheduled for a time post the resolution caught up. However the... (1 Reply)
Discussion started by: qwerty000
1 Replies

8. Shell Programming and Scripting

Take backup of scripts listed in crontab

Hi, I'm trying to take backups of script files listed in cron tab but,my cron entry has value like this 10 3 * * * /usr/sbin/logadm 15 3 * * 0 /usr/lib/fs/nfs/nfsfind 30 3 * * * && /usr/lib/gss/gsscred_clean #10 3 * * * /usr/lib/krb5/kprop_script ___slave_kdcs___ 00,15,30,45 * * * *... (1 Reply)
Discussion started by: Sivarajan N
1 Replies

9. Shell Programming and Scripting

Log file is not updating when I run shell scripts scheduled thru crontab

Hi Forum, Good Day! I have created an empty html file wtih permissoin 777 created shell script(with permission 777) , code is below. #=======================start============== . /data09/oracle/apps_st/appl/D_oraapp095.env rm -rf /home/mnp/Test_log.txt echo... (1 Reply)
Discussion started by: kartheekbk
1 Replies

10. Shell Programming and Scripting

Multiple scripts in one single script - crontab

Hello all, Hope all's well. i'm not sure if this is possible but i have some scripts running in a crontab with different intervals, 1min, 5 min, etc. As for a "cleaner" and better control of these scripts (as by time we will have hundred's of scripts used for the same purpose, i.e for Nagios... (4 Replies)
Discussion started by: nms
4 Replies
CSS::Minifier(3pm)					User Contributed Perl Documentation					CSS::Minifier(3pm)

NAME
CSS::Minifier - Perl extension for minifying CSS SYNOPSIS
To minify a CSS file and have the output written directly to another file use CSS::Minifier qw(minify); open(INFILE, 'myStylesheet.css') or die; open(OUTFILE, 'myStylesheet.css') or die; minify(input => *INFILE, outfile => *OUTFILE); close(INFILE); close(OUTFILE); To minify a CSS string literal. Note that by omitting the outfile parameter a the minified code is returned as a string. my minifiedCSS = minify(input => 'div {font-family: serif;}'); To include a copyright comment at the top of the minified code. minify(input => 'div {font-family: serif;}', copyright => 'BSD License'); The "input" parameter is manditory. The "output" and "copyright" parameters are optional and can be used in any combination. DESCRIPTION
This module removes unnecessary whitespace from CSS. The primary requirement developing this module is to not break working stylesheets: if working CSS is in input then working CSS is output. The Mac/Internet Explorer comment hack will be minimized but not stripped and so will continue to function. This module understands space, horizontal tab, new line, carriage return, and form feed characters to be whitespace. Any other characters that may be considered whitespace are not minimized. These other characters include paragraph separator and vertical tab. For static CSS files, it is recommended that you minify during the build stage of web deployment. If you minify on-the-fly then it might be a good idea to cache the minified file. Minifying static files on-the-fly repeatedly is wasteful. EXPORT None by default. Exportable on demand: minifiy() SEE ALSO
This project is developed using an SVN repository. To check out the repository svn co http://dev.michaux.ca/svn/random/CSS-Minifier You may also be interested in the JavaScript::Minifier module also available on CPAN. AUTHORS
Peter Michaux, <petermichaux@gmail.com> COPYRIGHT AND LICENSE
Copyright (C) 2007 by Peter Michaux This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.6 or, at your option, any later version of Perl 5 you may have available. perl v5.12.3 2007-08-03 CSS::Minifier(3pm)
All times are GMT -4. The time now is 07:58 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy