If you can't control the jobs so they won't write to the audit table at the same time, there are a number of options available to you.
have the audit table store in a schema that supports simultaneous updates. Examples of this is SAS/SHARE, SAS SPD Server, end practically any other RDBMS.
Make a macro that checks if a lock is available on the audit table, if not, wait for n seconds and then retries, and so on.
Have the individual audit tables. They could be appended in an ordered fashion once a day (or any other time interval that suits your needs).
Data never sleeps
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.