Views [dbo].[ujo_jobst]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnNo
Created2:45:32 PM Saturday, July 19, 2008
Last Modified2:45:32 PM Saturday, July 19, 2008
Columns
Name
joid
job_name
job_type
box_joid
owner
permission
machine
n_retrys
auto_hold
command
date_conditions
days_of_week
run_calendar
exclude_calendar
start_times
start_mins
run_window
description
term_run_time
box_terminator
job_terminator
std_in_file
std_out_file
std_err_file
watch_file
watch_file_min_size
watch_interval
min_run_alarm
max_run_alarm
alarm_if_fail
chk_files
free_procs
profile
heartbeat_interval
job_load
priority
auto_delete
numero
max_exit_success
box_success
box_failure
send_notification
service_desk
status
status_time
run_num
ntry
appl_ntry
last_start
last_end
next_start
exit_code
run_machine
que_name
run_priority
next_priority
pid
jc_pid
time_ok
last_heartbeat
timezone
as_applic
as_group
Permissions
TypeActionOwning Principal
GrantSelectujoadmin
SQL Script
SET QUOTED_IDENTIFIER OFF
GO

CREATE VIEW  ujo_jobst
AS
SELECT j.*, status, status_time, run_num, ntry, appl_ntry, last_start,
    last_end,next_start,exit_code,run_machine, que_name,
    run_priority, next_priority, pid, jc_pid,time_ok,
    last_heartbeat, j2.timezone,j2.as_applic,j2.as_group
FROM ujo_job j, ujo_job_status s, ujo_job2 j2
WHERE j.joid = s.joid and j.joid = j2.joid

GO
GRANT SELECT ON  [dbo].[ujo_jobst] TO [ujoadmin]
GO
Uses
Used By