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
to export the query as a job for automating the operations. Once 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.
Once
a job is stored in metadata, you can open the job to edit it with
SAS Data Integration Studio. 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,
tables, or folders), 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.
-
Enter a name and specify
a location. Click
Export.