Script runs manually, Not working in Cron
0
I can able to run my script manually all the commands works fine, When i run my script in cron its not working throwing a error.
Script
#! /bin/sh -x
PATH=/bin:/sbin:/usr/bin:/usr/sbin
/bin/sh /etc/profile
increment=0
if [ $increment != 0 ]
then
sqlcmd -h-1 -S PRD-DB-02.ics.com -U sa -P 'SQL h@$ N0 =' -d ge -i input.sql -W -w 1024 -s"," >> output.csv
else
echo "header printed!"
sqlcmd -S PRD-DB-02.ics.com -U sa -P 'SQL h@$ N0 =' -d ge -i input.sql -W -w 1024 -s"," >> output.csv
fi
increment+=1
sed -e 's/-,//g;s/-//g;s/,,//g;/^$/d' output.csv > Uploadstatus.csv
rm -rf output.csv
Cron entry
2 * * * * /script.sh
Error:
+ PATH=/bin:/sbin:/usr/bin:/usr/sbin
+ /bin/sh /etc/profile
+ increment=0
+ '[' 0 '!=' 0 ']'
+ echo 'header printed!'
header printed!
+ sqlcmd -S PRD-DB-02.ics.com -U sa -P 'SQL h@$ N0 =' -d ge -i input.sql -W -w 1024 -s,
/script.sh: line 16: **sqlcmd: command not found**
+ increment+=1
+ sed -e 's/-,//g;s/-//g;s/,,//g;/^$/d' output.csv
+ rm -rf output.csv
shell sqlcmd
edited Nov 21 '18 at 14:35
Andre Gelinas
522138
asked Nov 21 '18 at 12:16
guhan v
1
add a comment |
0
I can able to run my script manually all the commands works fine, When i run my script in cron its not working throwing a error.
Script
#! /bin/sh -x
PATH=/bin:/sbin:/usr/bin:/usr/sbin
/bin/sh /etc/profile
increment=0
if [ $increment != 0 ]
then
sqlcmd -h-1 -S PRD-DB-02.ics.com -U sa -P 'SQL h@$ N0 =' -d ge -i input.sql -W -w 1024 -s"," >> output.csv
else
echo "header printed!"
sqlcmd -S PRD-DB-02.ics.com -U sa -P 'SQL h@$ N0 =' -d ge -i input.sql -W -w 1024 -s"," >> output.csv
fi
increment+=1
sed -e 's/-,//g;s/-//g;s/,,//g;/^$/d' output.csv > Uploadstatus.csv
rm -rf output.csv
Cron entry
2 * * * * /script.sh
Error:
+ PATH=/bin:/sbin:/usr/bin:/usr/sbin
+ /bin/sh /etc/profile
+ increment=0
+ '[' 0 '!=' 0 ']'
+ echo 'header printed!'
header printed!
+ sqlcmd -S PRD-DB-02.ics.com -U sa -P 'SQL h@$ N0 =' -d ge -i input.sql -W -w 1024 -s,
/script.sh: line 16: **sqlcmd: command not found**
+ increment+=1
+ sed -e 's/-,//g;s/-//g;s/,,//g;/^$/d' output.csv
+ rm -rf output.csv
shell sqlcmd
edited Nov 21 '18 at 14:35
Andre Gelinas
522138
asked Nov 21 '18 at 12:16
guhan v
1
2
Add the full path for sqlcmd.
– Andre Gelinas
Nov 21 '18 at 12:43
Possible duplicate of bash script running from cronjob command not found
– Corion
Nov 21 '18 at 14:09
add a comment |
0
0
0
I can able to run my script manually all the commands works fine, When i run my script in cron its not working throwing a error.
Script
#! /bin/sh -x
PATH=/bin:/sbin:/usr/bin:/usr/sbin
/bin/sh /etc/profile
increment=0
if [ $increment != 0 ]
then
sqlcmd -h-1 -S PRD-DB-02.ics.com -U sa -P 'SQL h@$ N0 =' -d ge -i input.sql -W -w 1024 -s"," >> output.csv
else
echo "header printed!"
sqlcmd -S PRD-DB-02.ics.com -U sa -P 'SQL h@$ N0 =' -d ge -i input.sql -W -w 1024 -s"," >> output.csv
fi
increment+=1
sed -e 's/-,//g;s/-//g;s/,,//g;/^$/d' output.csv > Uploadstatus.csv
rm -rf output.csv
Cron entry
2 * * * * /script.sh
Error:
+ PATH=/bin:/sbin:/usr/bin:/usr/sbin
+ /bin/sh /etc/profile
+ increment=0
+ '[' 0 '!=' 0 ']'
+ echo 'header printed!'
header printed!
+ sqlcmd -S PRD-DB-02.ics.com -U sa -P 'SQL h@$ N0 =' -d ge -i input.sql -W -w 1024 -s,
/script.sh: line 16: **sqlcmd: command not found**
+ increment+=1
+ sed -e 's/-,//g;s/-//g;s/,,//g;/^$/d' output.csv
+ rm -rf output.csv
shell sqlcmd
edited Nov 21 '18 at 14:35
Andre Gelinas
522138
asked Nov 21 '18 at 12:16
guhan v
1
I can able to run my script manually all the commands works fine, When i run my script in cron its not working throwing a error.
Script
#! /bin/sh -x
PATH=/bin:/sbin:/usr/bin:/usr/sbin
/bin/sh /etc/profile
increment=0
if [ $increment != 0 ]
then
sqlcmd -h-1 -S PRD-DB-02.ics.com -U sa -P 'SQL h@$ N0 =' -d ge -i input.sql -W -w 1024 -s"," >> output.csv
else
echo "header printed!"
sqlcmd -S PRD-DB-02.ics.com -U sa -P 'SQL h@$ N0 =' -d ge -i input.sql -W -w 1024 -s"," >> output.csv
fi
increment+=1
sed -e 's/-,//g;s/-//g;s/,,//g;/^$/d' output.csv > Uploadstatus.csv
rm -rf output.csv
Cron entry
2 * * * * /script.sh
Error:
+ PATH=/bin:/sbin:/usr/bin:/usr/sbin
+ /bin/sh /etc/profile
+ increment=0
+ '[' 0 '!=' 0 ']'
+ echo 'header printed!'
header printed!
+ sqlcmd -S PRD-DB-02.ics.com -U sa -P 'SQL h@$ N0 =' -d ge -i input.sql -W -w 1024 -s,
/script.sh: line 16: **sqlcmd: command not found**
+ increment+=1
+ sed -e 's/-,//g;s/-//g;s/,,//g;/^$/d' output.csv
+ rm -rf output.csv
shell sqlcmd
shell sqlcmd
edited Nov 21 '18 at 14:35
Andre Gelinas
522138
asked Nov 21 '18 at 12:16
guhan v
1
edited Nov 21 '18 at 14:35
Andre Gelinas
522138
asked Nov 21 '18 at 12:16
guhan v
1
edited Nov 21 '18 at 14:35
Andre Gelinas
522138
edited Nov 21 '18 at 14:35
Andre Gelinas
522138
edited Nov 21 '18 at 14:35
Andre Gelinas
522138
522138
asked Nov 21 '18 at 12:16
guhan v
1
asked Nov 21 '18 at 12:16
guhan v
1
asked Nov 21 '18 at 12:16
guhan v
1
1
2
Add the full path for sqlcmd.
– Andre Gelinas
Nov 21 '18 at 12:43
Possible duplicate of bash script running from cronjob command not found
– Corion
Nov 21 '18 at 14:09
add a comment |
2
Add the full path for sqlcmd.
– Andre Gelinas
Nov 21 '18 at 12:43
Possible duplicate of bash script running from cronjob command not found
– Corion
Nov 21 '18 at 14:09
2
2
Add the full path for sqlcmd.
– Andre Gelinas
Nov 21 '18 at 12:43
Add the full path for sqlcmd.
– Andre Gelinas
Nov 21 '18 at 12:43
Possible duplicate of bash script running from cronjob command not found
– Corion
Nov 21 '18 at 14:09
Possible duplicate of bash script running from cronjob command not found
– Corion
Nov 21 '18 at 14:09
add a comment |
1 Answer
1
active
oldest
votes
0
The script.sh file should have the execute permission for the user under which the cron tab has been set. Try the bellow,
chmod 755 script.sh
answered Nov 21 '18 at 14:41
Jeevan
1326
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53411850%2fscript-runs-manually-not-working-in-cron%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
The script.sh file should have the execute permission for the user under which the cron tab has been set. Try the bellow,
chmod 755 script.sh
answered Nov 21 '18 at 14:41
Jeevan
1326
add a comment |
0
The script.sh file should have the execute permission for the user under which the cron tab has been set. Try the bellow,
chmod 755 script.sh
answered Nov 21 '18 at 14:41
Jeevan
1326
add a comment |
0
0
0
The script.sh file should have the execute permission for the user under which the cron tab has been set. Try the bellow,
chmod 755 script.sh
answered Nov 21 '18 at 14:41
Jeevan
1326
The script.sh file should have the execute permission for the user under which the cron tab has been set. Try the bellow,
chmod 755 script.sh
answered Nov 21 '18 at 14:41
Jeevan
1326
answered Nov 21 '18 at 14:41
Jeevan
1326
answered Nov 21 '18 at 14:41
Jeevan
1326
answered Nov 21 '18 at 14:41
Jeevan
1326
1326
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53411850%2fscript-runs-manually-not-working-in-cron%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Add the full path for sqlcmd.
– Andre Gelinas
Nov 21 '18 at 12:43
Possible duplicate of bash script running from cronjob command not found
– Corion
Nov 21 '18 at 14:09