APTgetJobTypeName

This function can be used to query database tables related to backup job details, such as apt_v_job and apt_v_nbu_job.

FUNCTION APTgetJobTypeName(
productType,
jobType,
vendorJobType)

This function returns a character string.

Note:

In the SQL Template Designer query, the function name must be prefaced with: rtd.

Example Query 1

SELECT rtd.APTgetJobTypeName(j.product_type, j.job_type, NULL) 
FROM apt_v_job j

Example Query 2

SELECT rtd.APTgetJobTypeName(j.product_type, j.job_type, n.vendor_job_type)
FROM apt_v_nbu_job n, apt_v_Job j
WHERE j.job_id = n.job_id

The output from this example:

Full Backup
Appl Backup
Appl Backup