LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 2008, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Sat, 17 May 2008 20:56:34 -0400
Reply-To:   SUBSCRIBE SAS-L Siva Rao <gssrao_1941@YAHOO.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   SUBSCRIBE SAS-L Siva Rao <gssrao_1941@YAHOO.COM>
Subject:   updating a sas dataset by multiple jobs

Hi , I am trying to read/write a SAS dataset by multiple jobs running concurrently. Here are some details on my task that I am trying to achieve:

1. I will run my process on UNIX and using sas9.x 2. I will create a sas dataset (permanent dataset) called "control" with 2 columns: JOb_name and FLAG.

3. I have total 4 jobs, JOB1, JOB2, JOB3, JOB4 to run. and I like to submit all 4 using SYSTASK COMMAND to run consurrently. At the very end of JOB1, JOB2, and JOB3, I will insert/write a record to "control" dataset to mark the completion of the job. For example as below:

Proc sql; insert into X.control values('JOB1','1'); quit;

JOb4 should run only after the successful completion of JOB1, JOB2, JOB3. So, in JOB4 I am using sleep commmand so that It will be active in the background and will keep checking the "CONTROL" dataset (created in step2) for the JOb_name and FLAG and if it finds that JOB1, JOB2, JOB3 are completed then Job should start processing.

My question is : How can I make the "CONTROL" dataset available for JOB1/2/3 for wrting and available to JOB4 for reading without any deadlock or without failing the jobs and without any data inconsistency?

Can you please help me? THANK YOU SO MUCH in advance.


Back to: Top of message | Previous page | Main SAS-L page