02-23-2007
Use absolute path for "validation/cnt_*.sql" like /x/y/z/validation/cnt_*.sql then give a try. by default cron will try to find that in /validation/cnt_*.sql which is causing the error..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to schedule a job in linux through the crontab command.My script actually does some text processing and echoes some output.My cron scheduler is working fine,but the output messages(echoes from script) is mailed to my mail account(in unix -/var/local/mail).Is it not possible... (0 Replies)
Discussion started by: DILEEP410
0 Replies
2. HP-UX
Hi all,
I need to run a shell script every 6 days using crontab. I've been searching a bit and found the following syntax for this:
* * */6 * * /apps/temp/maxx.sh > /apps/temp/maxx.log 2>&1
respectively
* * 0/6 * * /apps/temp/maxx.sh > /apps/temp/maxx.log 2>&
Unfortunately when trying to... (8 Replies)
Discussion started by: Endo
8 Replies
3. UNIX for Advanced & Expert Users
Hi,
we reboot our Linux server yesterday and since then (specialy last night) no job from crontab has run. Any idea ? What should I look for to investigate?
Many thanks. (5 Replies)
Discussion started by: big123456
5 Replies
4. Solaris
Hi experts,
I want to set the crontab for my script which will run every 20 seconds
I think below could be the possible one-
*/3 * * * * /export/home/username/scripts/runing.sh
As my system(SOLARIS 9) is live- i am confused to implement before make sure !!!
I need... (4 Replies)
Discussion started by: thepurple
4 Replies
5. Shell Programming and Scripting
hi i have a script called test.sh. the content is ls >> crontest.txt.
if i run manually it's giving output.but if i scheduled in crontab it's not giving output.
crontab entry:
02 * * * * /sms5/SMSHOME/eds_sh/test.sh >> /sms5/SMSHOME/eds_sh/testfile/logfile 2>&1
I am using ksh.is there... (2 Replies)
Discussion started by: muraliinfy04
2 Replies
6. Shell Programming and Scripting
Hi,
I have a script which checks to see if an app is running and will restart it if it is not.
For some reason when I run it from the crontab it always says it is not running.
The script is as follows: -
#!/bin/sh
#
# The following script will look for the PID of SickBeard and output... (15 Replies)
Discussion started by: simpic
15 Replies
7. HP-UX
Hi All
I have a problem, I wonder if you can help me sort it out:
I have the following entry in the cron:
00 1,13 * * * /home/report/opn_amt_gestores_credito.ksh > opn_amt_gestores_credito.log
But the entry only runs at 01:07
I have stopped the cron deamon, and started, but it still... (39 Replies)
Discussion started by: fretagi
39 Replies
8. Shell Programming and Scripting
Hello all,
I'm trying to write a script to gather and send data and it works just fine at the bash command line, but when executing from CRON, it does not run properly.
My scripting skills are pretty limited and there's probably a better way, but as I said it works at the command line, but... (12 Replies)
Discussion started by: rusman
12 Replies
9. UNIX for Dummies Questions & Answers
I am from MQ/MB technology. My requirement is to display the queue manger and broker status on daily basis.
If I manually run the script, it works fine and displays output. But when I have scheduled the same using cronjobs it shows only the queue manger status and not the broker status.
Can... (3 Replies)
Discussion started by: Anusha M
3 Replies
10. Shell Programming and Scripting
I'm trying to get a crontab to run, every Friday at 11am and the problem is that it isn't running at all.
0 11 * * 6 /Users/martinb/Documents/SYSADMIN/Regular-Scripts/Info-And-Backups.sh
Here's a link to a screenshot of my script (I've censored my email address).
Screen Shot 2017 11 03... (3 Replies)
Discussion started by: $shell_Learner
3 Replies
LEARN ABOUT PHP
db2_num_fields
DB2_NUM_FIELDS(3) 1 DB2_NUM_FIELDS(3)
db2_num_fields - Returns the number of fields contained in a result set
SYNOPSIS
int db2_num_fields (resource $stmt)
DESCRIPTION
Returns the number of fields contained in a result set. This is most useful for handling the result sets returned by dynamically generated
queries, or for result sets returned by stored procedures, where your application cannot otherwise know how to retrieve and use the
results.
PARAMETERS
o $stmt
- A valid statement resource containing a result set.
RETURN VALUES
Returns an integer value representing the number of fields in the result set associated with the specified statement resource. Returns
FALSE if the statement resource is not a valid input value.
EXAMPLES
Example #1
Retrieving the number of fields in a result set
The following example demonstrates how to retrieve the number of fields returned in a result set.
<?php
$sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed";
$stmt = db2_prepare($conn, $sql);
db2_execute($stmt, $sql);
$columns = db2_num_fields($stmt);
echo "There are {$columns} columns in the result set.";
?>
The above example will output:
There are 4 columns in the result set.
SEE ALSO
db2_execute(3), db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3),
db2_field_type(3), db2_field_width(3).
PHP Documentation Group DB2_NUM_FIELDS(3)