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.