Right now I am using import export wizard to take backup of all the jobs and sas datasets. Can I some how right a script to automate this procedure? The %OMABAKUP takes only the meta data backup. It does not take backup of the physical content like jobs, datasets. So can this be acheived?
Aren't mixing up a bit here?
Export wizard exports metadata into package files.
%omabakup copies metadata to different location.
Neither of these backups "physical" stuff like deployed jobs (.sas files) and tables.
So, %omabackup is probably a better choice if your environment is large a need an automated process for backing up metadata.
To backup physical files, you will probably use 3rd party software to do the job. If you have your data stored in external RDBMS or SPDS, refer to that products documentation regarding backup strategies.
Usually, backup jobs are not defined within DI Studio.
Agreed. So can I some how automate the process of creating an spk file?
Also do you mean that %omabackup will take backup of metadata of entire repository, like jobs, datasets, db tables, libraries, user written transformations, etc.?
Also if I restore this metadata backup on a diff server will I be able to run the jobs in a similar way? (ofcourse considering that the physical tables are moved to that particular location and connections to rdbms is made.)