Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - How i can schedule the Informatica job in "Unix Corn Scheduling tool" ?




493
views
asked marvit September 20, 2014 08:03 AM  

How i can schedule the Informatica job in "Unix Corn Scheduling tool" ?


           

1 Answers



 
answered By vishnoiprem   0  
Crontab
The crontab (cron derives from chronos, Greek for time; tab stands for table) command, found in Unix and Unix-like operating systems, is used to schedule commands to be executed periodically. To see what crontab are currently running on your system, you can open a terminal and run:
sudo crontab -l
To edit the list of cronjobs you can run:
sudo crontab -e
This wil open a the default editor (could be vi or pico, if you want you can change the default editor) to let us manipulate the crontab. If you save and exit the editor, all your cronjobs are saved into crontab. Cronjobs are written in the following format:
* * * * * /bin/execute/this/script.sh
Scheduling explained
As you can see there are 5 stars. The stars represent different date parts in the following order:
1.    minute (from 0 to 59)
2.    hour (from 0 to 23)
3.    day of month (from 1 to 31)
4.    month (from 1 to 12)
5.    day of week (from 0 to 6) (0=Sunday)
Execute every minute
If you leave the star, or asterisk, it means every. Maybe that’s a bit unclear. Let’s use the the previous example again:
* * * * * /bin/execute/this/script.sh
They are all still asterisks! So this means
execute /bin/execute/this/script.sh:
1.    every minute
2.    of every hour
3.    of every day of the month
4.    of every month
5.    and every day in the week.
In short: This script is being executed every minute.
Without exception.
Execute every Friday 1AM
So if we want to schedule the script to run at 1AM every Friday, we would need the following cronjob:
0 1 * * 5 /bin/execute/this/script.sh
Get it? The script is now being executed when the system
clock hits:
1.    minute: 0
2.    of hour: 1
3.    of day of month: * (every day of month)
4.    of month: * (every month)
5.    and weekday: 5 (=Friday)
Execute on weekdays 1AM
So if we want to schedule the script to run at 1AM every
Friday, we would need the following cronjob:
0 1 * * 1-5 /bin/execute/this/script.sh
Get it? The script is now being executed when the system
clock hits:
1.    minute: 0
2.    of hour: 1
3.    of day of month: * (every day of month)
4.    of month: * (every month)
5.    and weekday: 1-5 (=Monday til Friday)
Execute 10 past after every hour on the 1st of every month
Here’s another one, just for practicing
10 * 1 * * /bin/execute/this/script.sh
Fair enough, it takes some getting used to, but it offers
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert