topic Re: Running jobs end to end on SAS DI in SAS Data Management

Running jobs end to end on SAS DI

meatballs12345 — Tue, 08 Feb 2022 02:14:04 GMT

Hi everyone,

Is it okay to run jobs end to end on SAS DI even if you don't have the change management profile? I'm unsure if it's okay to have the job finish until loading/updating the Oracle tables, will be the tables overwritten? Currently, I still don't have the change management profile and is trying to test and run on the dev server, I created my own test folder on My Folder, copied and pasted the jobs there. When running the jobs I just exclude the loading to Oracle process although I'm having trouble validating the results since sometimes the temporary tables are not enough for me if the results were impacted by my changes.

TIA!

Re: Running jobs end to end on SAS DI

Patrick — Tue, 08 Feb 2022 07:50:40 GMT

DIS change management will allow you to check in/check out SAS metadata so you can apply changes to SAS metadata objects on a "copy" plus it also ensures that no one else is changing the same object at the same time (IF everybode uses change control).

BUT: This is only about SAS metadata. The code that gets generated still is "the same" and this code will do whatever you've set-up - which includes changing data in a physical target table. The physical target table remains the same whether your table metadata object is checked out or not.

Re: Running jobs end to end on SAS DI

meatballs12345 — Wed, 09 Feb 2022 01:10:05 GMT

Thanks, Patrick!

"BUT: This is only about SAS metadata. The code that gets generated still is "the same" and this code will do whatever you've set-up - which includes changing data in a physical target table. The physical target table remains the same whether your table metadata object is checked out or not."

-Does it mean that whatever I do, AS LONG AS I'm on a dev server (using change management or not) data will remain unchanged UNLESS I check it in, correct?

Re: Running jobs end to end on SAS DI

LinusH — Wed, 09 Feb 2022 21:06:15 GMT

No.

You must understand the difference between metadata (which you check-out/in under change management) and data (e.g. in Oracle tables).

Data will be unchanged until you execute your job/code.

Re: Running jobs end to end on SAS DI

meatballs12345 — Wed, 09 Feb 2022 23:56:04 GMT

Thanks @LinusH!
"Data will be unchanged until you execute your job/code."
-Yup, but under the change management, the original copy of the data will not be affected right? Then is it safe to run the whole job end to end? Sorry for having too many questions, DIS so new to me.
Thanks!

Re: Running jobs end to end on SAS DI

LinusH — Thu, 10 Feb 2022 15:13:19 GMT

Change management in SAS has nothing to do with your data in your database.

Please talk to your system/SAS admin/scrum master/architect to get a better understandin on how your environment is setup/working.