- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
We have SAS Analytics Pro running on a Windows server - all stable, running for 3 months now.
I currently have 3 ETL jobs, each triggered by a scheduled *.bat file.
I have these jobs running one at a time, each of them is accessing a different database.
I will soon need to add more ETL jobs and wanted to know if I could move things around to have jobs running at the same time and if I did this, are there any gotcha's I should I look out for or advise you could give.
Thanks in advance
Jim
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
The gotcha's I can think of is
- Resources: physical, and check your SAS global options for MEMSIZE/SORTSIZE
- Job dependencies - reading/updating the same tables
If you start to get plenty of jobs, it could be wise to investigate in using a scheduling tool so can get a better overview/control of your environment.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
The gotcha's I can think of is
- Resources: physical, and check your SAS global options for MEMSIZE/SORTSIZE
- Job dependencies - reading/updating the same tables
If you start to get plenty of jobs, it could be wise to investigate in using a scheduling tool so can get a better overview/control of your environment.