DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2001


    What's the difference between running a job as a cron job and a batch job?

  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    cron job is programmed, batch job is doing loads of tasks in a go.
    they are both related because normally you program batch jobs with cron and to execute them in an hour when the activity is low (early morning like 2 am to 4 am for example depending your company)
    cron jobs can be batch jobs, backups, monitoring etc
    batch jobs can be mass data loading, mass updating etc

  3. #3
    Join Date
    Nov 2000
    "cron" is usually mentioned as a Unix utility- which basically calls a script or a "one-liner" at any given time or interval listed in your crontab. I'm not sure if the actual cron program is available for NT- I just use Unix.

    So ... if you have a unix box just try the man page:

    %man cron

    You may try:

    %crontab -l

    Which will list the current cronjobs for the current user.

    %crontab -e

    will edit the crontab. Make sure you do a:

    export EDITOR=vi

    so that cron knows which editor you use.

  4. #4
    Join Date
    Aug 2000
    Another difference between a 'crontab'-job and an 'at'-job.

    When you issue a job using at, the unix-environment is automatically put in the job. eg. when you have set your oracle environment, and you start a job using at, automaticly you have the right oracle settings.

    When you issue a job using crontab, you have to set the environment in the script. That's why I always begin a crontab job with
    . /etc/profile
    . $HOME/.profile


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.