https://communities.sas.com/t5/ODS-and-Base-Reporting/Refresh-the-dataset-if-someone-working-on-it/m-p/1277#M594 This is an appropriate question for Technical Support. See<BR /> <A href="http://support.sas.com/techsup/contact/submit_emits2.html" target="_blank">http://support.sas.com/techsup/contact/submit_emits2.html</A> .<BR /> <BR /> -- David Kelley, SAS Fri, 18 Aug 2006 18:39:35 GMT David_SAS 2006-08-18T18:39:35Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Refresh-the-dataset-if-someone-working-on-it/m-p/1276#M593 my cron jobs will refresh nearlly all the DW datasets everyday, but sometimes job will fail because of a lock on the table, what i do is to kill the job which is holding a lock and run the job.<BR /> <BR /> Is there anyway i can override this Thu, 17 Aug 2006 23:49:06 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Refresh-the-dataset-if-someone-working-on-it/m-p/1276#M593 deleted_user 2006-08-17T23:49:06Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Refresh-the-dataset-if-someone-working-on-it/m-p/1277#M594 This is an appropriate question for Technical Support. See<BR /> <A href="http://support.sas.com/techsup/contact/submit_emits2.html" target="_blank">http://support.sas.com/techsup/contact/submit_emits2.html</A> .<BR /> <BR /> -- David Kelley, SAS Fri, 18 Aug 2006 18:39:35 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Refresh-the-dataset-if-someone-working-on-it/m-p/1277#M594 David_SAS 2006-08-18T18:39:35Z