I have a shell script which contain database connection and runs a big query.
When I run the script on command promp, the desired output is getting spooled taking some time.
But when I setup a cronjob for that script, the spool file is not getting generated.

What could be the problem?

Thanks in advance