How i can Schdule the Informatica job in "Unix Corn
Schduling tool" ?
- 2 Answers
- 10949 Views
- I also Faced
- E-Mail Answers
Answer Posted / ram
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 crontabs 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
great flexibility.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Explain what are the different versions of informatica?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How might you approve all mappings in the archive all the while?
What is meant by lookup transformation?
What are data-driven sessions?
Briefly define a session task?
What is an expression transformation in informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the types of presistent cache in look up tr.
What are junk dimensions?
Briefly define reusable transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
Explain about cumulative Sum or moving sum?
While migrating the data from one environment to another environment how would you manage the connections?
Under which circumstances, informatica server creates reject files?
