Solved

Sybase - CronJob schedule

Posted on 2013-11-21
2
582 Views
Last Modified: 2013-11-25
I found a following cronjob  for Sybase db in Solaris. Does anyone know when and teh frequency of this cronjob ?

I'm thinking to get a new cronjob which will run daily at 07:00am, 12:00PM and 16:00PM, how we do that ?

30 19,21,23 * * 1,3,5,0 /opt/sybase/home/edt_local/bin/backup_sybase UPM_TR  -trans
30 01,03,05,07,09,11,13,15 * * 2,4,6 /opt/sybase/home/edt_local/bin/backup_sybase UPM_TR -trans
0
Comment
Question by:motioneye
2 Comments
 
LVL 82

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 100 total points
ID: 39668277
This page http://docs.oracle.com/cd/E23824_01/html/821-1451/sysrescron-1.html#sysrescron-62861 shows what all the values represent in Solaris.
0
 
LVL 19

Accepted Solution

by:
xterm earned 400 total points
ID: 39670845
The first one runs at 7:30P, 9:30P, and 11:30P on Sunday, Monday, Wednesday and Friday

The second one runs at 1:30A, 3:30A,5:30A,7:30A,9:30A,11:30A,1:30P, and 3:30P on Tuesday, Thursday and Saturday

Your new desired cronjob would look like this:

  0 7,12,16 * * * /path/to/your_script

This is an explanation of the fields:

              field          allowed values
              -----          --------------
              minute         0-59
              hour           0-23
              day of month   1-31
              month          1-12 (or names)
              day of week    0-7 (0 or 7 is Sunday, or use names)
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now