Running jobs end to end on SAS DI

[tsndrct1234]

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!

[Patrick]

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.

[tsndrct1234]

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?

[LinusH]

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.

[tsndrct1234]

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!

[LinusH]

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.