For deployments that
include SAS Data Integration Studio and prefer to deploy jobs, flows,
and schedule flows manually, you can export a query as a job, and
then perform the deployment steps.
This feature enables
you to work with a query interactively while you design it, and then
you can export the 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 query and export it as a job again. However, you
cannot overwrite job objects in metadata with SAS Visual Data Builder.
If you need to delete objects from metadata (such as jobs, libraries,
or tables), use SAS Management Console.
To export a query as
a job:
-
Use the SAS Folders
tree to locate the query.
-
Select the 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.