Posts by aman_dba

You might also try appending "> /tmp/cronout.log" to the job to see if you get any error output from the execution. Could be a problem with the environment that the script is running in, too.

I hav not got any such log file under /tmp directory, is there any other possible location for the same???

Hmmm.

You can see process with many ways like (top, ps) etc. Let's try to solve your problem.

create a filed like /home/checkmycron.sh. In this file paste these lines.

#!/bin/sh
stamp=`/usr/bin/date | awk '{print $4}'`
/usr/bin/mkdir /tmp/my_test_dir-$stamp

save the file and make it executable with this command.

chmod +x /home/checkmycron.sh

Make sure (date and mkdir) path. Because some time cron is not working without complete path.

The above script will create a file in /tmp/my_test_dir with time stamp. You just need to add this script in crontab like.

30 09 * * 3 /home/checkmycron.sh
01 14 * * 3 /home/checkmycron.sh
20 18 * * 3 /home/checkmycron.sh

On 18:20 check your /tmp/ directory there should be three files created. If you find 3 files with the time stamp as per your crontab then there is no problem with your crontab & we will do next step.

No such files are created, not even the my_test_dir directory in /tmp directory...

I believe its case with cron only, not with script or environment..

Hmmm.

Would you please write down here your crontab entries and also tell how much time take your first script to complete its process.

You need to check your system process in that time when your second script running through crontab.

entry for my crontab

30 09 * * 3 /bin/backup36M
01 14 * * 3 /bin/backup36N
20 18 * * 3 /bin/backup36E

it takes almost 40 secs to execute a script

and m sry, i don know how to check system process..if u can guide for the same as well

thanks

I don't think so about sleep mode.

I meant 01 not 10 or 20 or 30. I think you should try with 1,2,3,4,5,6,7,8,9 don't put 0 in single minute value.

And please send me cron logs.

Oct 28 09:01:01 server crond[4040]: (root) CMD (run-parts /etc/cron.hourly)
Oct 28 09:30:01 server crond[4333]: (root) CMD (/bin/backup36M)

this is last log entry, and this script didnt work and i understand wat u r talking abt, but i meant to say, that if i set jobs at 18:30 hrs or 9:20 hrs, that job is also not working, so it shud not b any issue with 0 at single minutes, as other jobs are not working as well...

hmm

Which OS you are using? and how many minutes you extended?. Try to use this.

1 14 * * 1 /bin/backup14N

Remove 0 from minutes. I think problem with 01,02,03,04,05,06,07,08,09. You don't need to put 0.

M using centOS, n i believe if i use few minutes like 5 to 10 mins, the cron job is running.
By any chance, do u think that cron goes to sleep mode, after some interval of time??
and 0 is not any issue, coz i also have set jobs like
30 9 * * *
and
20 18 * * *
and they are also not executing at their intervals...

hmm..

Then you need to see the output of your script while its execute. like.

01 14 * * 1 /bin/backup14N | mail -s "Your second script" i_tears@techbabu.com

well, the problem is, my sendmail is also not working. I hav checked the logs of cron, n it is simply showing that cron is taking that script, but i dunno why, i am not getting the script output.If i run script directly on the terminal, or if i set the cronjob to next few minutes, it executes very comfortably. This is wat surprising me alot...

Why you split your crontab into multiple lines? try this

30 9,14 * * 1 /bin/backup14M

i hav to run different scripts on different timings, thats why i hav split in different lines.

Hi

Did you check crontab logs?

hey

yeah i did...its showing that its taking that script at that very interval, but the script is not executing..

hi friends

well m facing a different sort of issue in my cron.
i hav set job like this

30 09 * * 1 /bin/backup14M
01 14 * * 1 /bin/backup14N
20 18 * * 1 /bin/backup14E

that is for every Monday at three different times.
but, first job executes well, later ones do not. I checked my scrip result at 14:05 hrs, and it was not executed, i change the job to 14:08 and it executed well at the specified time, then checked at 18:21 hrs for the output, again it didnt execute, and i changed the time to few more minutes and it executed at that time. All i noticed is, that if i change the time to few minutes, it executes, but it do not execute for big intervals.
Can anybody tell the problem and the respective solution

Mentionable:- I hav the checked the basic cron forums, so find my issue lil different from the mentioned.. Using centOS 5.3 system.

thanks in advance

do let me know if u face same issue

thanks anyways...

HI friends,

I have checked the forums, until i loose my patience, but didnt get any such query or reply, so finally posting my issue.
I hav a CentOS box installed as a server with static ip and windows client using it to connect to internet via squid(the proxy server) on LAN
Now wen i try to connect my Linux box outside my LAN, it is not even giving any reply to ping.
Do i need any specific settings with respect to static ip, to make it accessible outside the LAN.
Mentinable:- i hav installed squid for proxy server and samba for File accessing on LAN.

any kinda support will be appreciated
thanks

Hi friends

I had sorted this problem previously, but now i realized that there's only one database, that is having problem. I deleted the whole database and recreated it, still having the same issue, it gets hanged in between the application and ultimately we hav to restart the server to get it working.
Could anybody please tell, wat cud be the issue with database, as i am new with sql server, so cant even estimate from logs, as they shows only the time abt the restart of server, neither i am aware of any tools to diagnose it.

Thanks in advance...

hi friends

We are connecting to sql server with Java and jsp as front end for our application. We are almost 10 people connecting to same machine regularly. earlier, we were just 4 or 5 connecting to one machine, now all are connecting to same machine, coz of some policy reasons.
Now it stops responding to queries from application after ever few minutes or can say abt half hour, requires to restart.
is the reason be number of users connected. if so, i dont believe it should, as servers connect to hundreds of users at a time. PLease help to rectify this issue or to make it available for more users.

thanx in advance

Offcourse we need to decide as per the organizational needs, but the question is same, what needs diffrentaite them. Or lets take like that, how company decides that it need to use SAP or Oracle. what are the features that differentiate them??

Hi Friends

I am working as an asst. DBA in a Software Company. I am using SQL SERVER and Oracle 9i both to create and maintain database.
I am also pursuing my administration in Oracle. I usually analyze that most of the companies with high profile are using Oracle and SAP as Databases. My question is Why and How a company can decide , which database or technology do it require for its database.

Can we rate different technologies like Oracle, SAP,DB2, SQL Server on priority bases? If Yes then how can we priorities one over another??

thanx in advance.

hi friends

i am a new bee to the world of sql server, started with it a few months back...
i deleted a table from sql server by mistake, and trying to recover it. but i dont hav any backup concerned. is it possible to recover that table without backup, and if yes, then how??
please revert ASAP..

thanx in advance
Aman

hi peter

i have added this jar file to the project libraries
but still i am facing the same problem

hi friends
i am connecting to sql server with java through eclipse as IDE.
here's my base connectivity class to sql server

public class BaseDAO {

    public Connection getConnection() throws Exception
    {
        String userName = "aman";
        String password = "password";
        String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=amandb";

                    // step 1
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();

            // Step 2
        return DriverManager.getConnection(url, userName,password);

    }

}

but i use to get error like
No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=amandb

can anybody tell, if its error of jar file i added or some code specific error. kindly help if possible to solve the concerned issue

thanx in advance....

Hi firends

Got solution of this issue...

check this link....

http://www.linglom.com/2007/08/31/enable-remote-connection-to-sql-server-2005-express/#comments

cheers....

hi friends

I am new to SQL SERVER
I am using sql server 2005 enterprise for server and express for client m/cs.
Having issue while connecting from client to server. i have read some tutorials on net.
while connecting to server from my client machine, i usually get error: 18452. i have tried it with both windows and sql authentication.
I have also created a user on server end for this concern, but no use, as it says "not a valid windows NT user", even if the user name is computer or login name for computer.
help required in connectivity with server...
any kinda info or solution will be highly appreciated

thanks....

hi friends

I am new to SQL SERVER
I am using sql server 2005 enterprise for server and express for client m/cs.
Having issue while connecting from client to server. i have read some tutorials on net.
while connecting to server from my client machine, i usually get error: 18452. i have tried it with both windows and sql authentication.
I have also created a user on server end for this concern, but no use, as it says "not a valid windows NT user", even if the user name is computer or login name for computer.
help required in connectivity with server...
any kinda info or solution will be highly appreciated

thanks....

hye francis

it really helps, but i was not able to remove the service pack completely. it just helped me to install the specific pack i was trying to install

thanx anyways, my issue has been resolved

thanx for ur gr8 help.

cheers...

In Windows Server 2003 SP2, the "Remove" button for the service pack is available in the "Add or Remove Programs" item in Control Panel

Some times "Remove" button for the service pack is not available in the "Add or Remove Programs".This problem occurs if the previous service pack was installed by using the SETUP /n command. For example, this problem may occur if Windows Server 2003 Service Pack 1 (SP1) was installed by using this command.

Note The /n switch installs the service pack without creating a backup folder. You must have this backup folder to remove the service pack by using the Add or Remove Programs item in Control Panel. We recommend that you always create a backup folder when you install a service pack.

To work around this problem, remove the service pack by running the Spuninst.exe utility. The Spuninst.exe utility is located in the following folder:
%SystemRoot%\$NTServicepackUninstall$

hi friends

i have been trying to uninstall sp2 from windows server 2003.
i read that it require to start system in safe mode, and later i can uninstall sp2 from control panel, but it was not visible there.
can anybody guide??

thanx in advance...