For deployments that include SAS Data Integration Studio and prefer to
deploy jobs, create flows, and schedule flows manually, you can export a
data query as a job, and then perform the deployment steps.
This feature enables you to work with a data query interactively while you create
it, and then you can export the data
query as a job for automating the operations. After the job is exported, you can deploy
the job for scheduling with SAS Data Integration Studio. For more information about
deploying jobs, see
Scheduling in SAS.
After a job is stored in
metadata, you can open the job with SAS Data Integration Studio and edit it. This might be
necessary if you need to add or remove columns or change the column expression in
a
calculated column.
If the deployment does not include SAS Data Integration Studio, then you can modify
the data query and export it as a job again. However, you cannot
overwrite job objects in metadata with the data builder. If you need to delete objects from
metadata (such as jobs,
libraries, or tables), use SAS Management Console.
To export a data query
as a job:
-
Use the SAS Folders
tree to locate the data query.
-
Select the data query, right-click, and select
Export as a job.
-
In the
Export
as a Job window, enter a name and specify a location.
Click
Export.