Deploy and Exeute Jobs
After the Data Management Server is registered, you are ready to deploy and run jobs. There are four top-level folders listed for each registered Data Management Server:
- The Batch Jobs folder corresponds to the batch_jobs folder located in the Data Management Repository and is used to deploy data and process jobs in batch mode.
- The Profile Jobs folder contains any profiles that exist in the Data Management Repository that the Data Management Server installation points to. Profiles cannot be imported or exported within Data Management Server.
- The Real-Time Data Services folder corresponds to the data_services folder in the Data Management Repository and is used to deploy data jobs as a real-time service.
- The Real-Time Process Services folder corresponds to the process_services folder in the Data Management Repository and is used to deploy jobs as a real-time service.
A note about Profile Jobs: Only profiles that are resident in the Data Management Repository for your Data Management Server are visible in the Profile Jobs folder for the Data Management Server.
Batch and Profile Jobs
When you select the Batch Jobs folder or the Profile Jobs folder, a list of jobs displays in the right information pane exposing the following toolbar:
- Import: Enables you to import items from the repository. The import icon becomes active when you select a jobs folder under the Data Management Server.
- Export: Enables you to export the selected object to a repository.
- Run: Enables you to run the selected job.
- Permissions: Enables you to view permissions, or grant permissions to a job if you are the job owner. You cannot grant permissions for a Profile Job.
- Delete: Enables you to delete one or more selected objects.
- Find: Enables you to locate the selected item in the tree and display it.
Deploy a Batch Data Job
To deploy a batch data job to the Data Management Server, it is imported from the repository. This procedure assumes that the job has been exported to the repository in Data Management Studio.
- Highlight the batch jobs folder and select Import.
Import Batch Jobs
- Using the Import From Repository dialog box, navigate to the job or jobs to be deployed and check the box next to the job name, or select the box next to a folder name to select all jobs in that folder.
- Select Next.
Import from Repository Dialog Box
Note: It is recommended that you create the same folder structure on the Data Management Server that was created in Data Management Studio. If your jobs are in a sub-folder of batch jobs, create the same sub-folder when you import your jobs to the server. It is recommended that you build and test your batch jobs in the batch jobs folder (or in a sub-folder of it) because mirroring these folders will help preserve any references where one Data Management Studio job references another.
- Select the folder to import the items to and click Import to begin importing the selected jobs to the Data Management Server.
Import from Repository: Select Import Folder
- Once the import has completed successfully, select Close.
The jobs are now uploaded to the Batch Jobs folder on the Data Management Server.
Running Batch Jobs
Before running any batch jobs, check to see if the jobs use variables. If you have macro variables that are read from a configuration file, inform your server administrator so that the appropriate additions can be made to the macros configuration file on the Data Management Server. To run a batch job,
- Select the Data Management Server that contains the batch jobs. If you are prompted, log on to the server by entering your user ID and password, and then click Log On.
- Expand the Data Management Server jobs list and expand the Batch Jobs folder.
- In the information pane under the Batch Jobs tab, select the job name and then click Run. The Run Job dialog box opens where you can insert job variables.
- In the Run Job dialog box, click New Variable if the job is set up to use variables. Setting input variables is an optional step.
Run Batch Job: Insert New Variable
- Select Run. Notice that the Running Count column is updated.
Batch Jobs Run History
- Check the Run History tab for the job status and check the log when the job is finished running.
Running Profile Jobs
To run a profile job, complete the following steps:
- Select the name of the Data Management Server that contains the profile jobs you wish to run. If you are prompted, log on to the server by entering your user ID and password, and then click Log On.
- Expand the Profile Jobs folder and select the folder containing the jobs you want to run. The jobs are listed under the Profile tab in the information pane to the right.
- Select the job name, and then click Run.
Run Profile Jobs
- In the Run Process dialog box, enter a description for the job and click Macro Variables to provide one or more variables for the job.
Note: The first time you run a profile, a report is created. Use the Append to existing report option to continue writing to the existing report. To replace the existing report and start a new one, clear the Append to existing report option.
Run Process Dialog Box
- In the Profile Macro Variables dialog box, click New Macro Variable
and specify a value for the variable. Click OK. Setting input variables is an optional step and variables must be declared on the job.
- In the Run Process dialog box, click OK.
- Select the Run History tab for the job status.
Run History Toolbar
- Using the toolbar in Run History you can also view the job log, delete files or stop a process if a job is still running.