Scheduler maintenance grants
Repository access grants:
grant select on ws_meta to dsssched;
grant select on ws_meta_tables to dsssched;
grant select on ws_obj_type to dsssched;
grant select,insert on ws_user_adm to dsssched;
grant select,insert,update on ws_user_adm to dsssched;
grant select,alter on ws_wrk_job_dependency_seq to dsssched;
grant select on ws_table_attributes to dsssched;
Object access (job create) grants:
grant select on ws_obj_object to dsssched;
grant select on ws_obj_pro_map to dsssched;
grant select on ws_obj_project to dsssched;
grant select on ws_obj_group to dsssched;
grant select on ws_pro_gro_map to dsssched;
Scheduler status grants:
grant select on ws_wrk_audit_log to dsssched;
Scheduler status, and job deletion grants:
grant select,delete on ws_wrk_error_log to dsssched;
Scheduler status, poll grants:
grant select,update on ws_wrk_scheduler to dsssched;
Job creation grants:
grant select,insert,update,delete on ws_wrk_dependency to dsssched;
grant select,insert,update,delete on ws_wrk_job_ctrl to dsssched;
grant select,alter on ws_job_seq to dsssched;
grant select,alter on ws_task_seq to dsssched;
Job maintenance grants:
grant select,insert,delete on ws_wrk_job_log to dsssched;
grant select,update,delete on ws_wrk_job_run to dsssched;
grant select,insert,update,delete on ws_wrk_dependency to dsssched;
grant select,insert,update,delete on ws_wrk_job_dependency to dsssched;
grant select,delete on ws_wrk_job_thread to dsssched;
Task maintenance grants:
grant select,insert,update,delete on ws_wrk_task_ctrl to dsssched;
grant select,update,delete on ws_wrk_task_run to dsssched;
grant select,insert,delete on ws_wrk_task_log to dsssched;
grant select,insert,update on dss_parameter to dsssched;
Right mouse 'used by' option in parameters listing grants:
grant select on ws_pro_header to dsssched;
grant select on ws_pro_line to dsssched;
grant select on ws_scr_header to dsssched;
grant select on ws_scr_line to dsssched;
grant select on ws_load_tab to dsssched;
grant select on ws_load_col to dsssched;
grant select on ws_stage_tab to dsssched;
grant select on ws_stage_col to dsssched;
grant select on ws_dim_tab to dsssched;
grant select on ws_dim_col to dsssched;
grant select on ws_fact_tab to dsssched;
grant select on ws_fact_col to dsssched;
grant select on ws_agg_tab to dsssched;
grant select on ws_agg_col to dsssched;
A sample script to grant these privileges is shipped with QAD Data Warehouse Designer. This script is called 'grant_sched_access.sql' and can be found in the QAD program directory.
The scheduler maintenance utility does not require a QAD license key. The QAD Data Warehouse Designer software can be installed onto a PC, and this utility utilized without having to use the QAD 'Setup Administrator' utility.
SQL to return Scheduler Status
This SQL returns the scheduler status:
SELECT CASE
WHEN ws_stop_date IS NOT NULL
THEN 'STOPPED'
WHEN ((DATEDIFF(mi,ws_active_date,GETDATE()) - CONVERT(INTEGER,DATEDIFF(mi,ws_active_date,GETDATE())/60)*60) > 15 )
OR (CONVERT(INTEGER,DATEDIFF(mi,ws_active_date,GETDATE())/60)>0)
THEN 'NOT ACTIVE'
WHEN (((DATEDIFF(mi,ws_active_date,GETDATE()) - CONVERT(INTEGER,DATEDIFF(mi,ws_active_date,GETDATE())/60)*60)>((ws_interval/60)+10)
OR CONVERT(INTEGER,DATEDIFF(mi,ws_active_date,GETDATE())/60)>0)
AND ws_poll_flag=1)
THEN 'NOT ACTIVE'
ELSE 'Running'
END
FROM dbo.ws_wrk_scheduler
WHERE ws_name = 'YourSchedulerName'
The procedure sets the status in the metadata.
22.9 Reset Columns in Job and Task View
Job and Task Report headings can be reset by selecting the View/Reset Display Headings menu option from the scheduler window. The short-cut keys are Alt+V-R.
A dialog will ask you to confirm the request.
If you selected 'Yes' to reset the display settings, then a dialog will confirm once the reset has occurred.
