[dbo].[ujo_chk

[dbo].[ujo_chk_running]

(local) > mdb > Stored Procedures > dbo.ujo_chk_running

Properties
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Permissions

Type	Action	Owning Principal
Grant	Execute	ujoadmin

SQL Script

/****** Object:  Stored Procedure dbo.ujo_chk_running    Script Date: 12/1/2005 11:49:47 PM ******/

create proc ujo_chk_running
AS

select    job_name, last_start
from    ujo_jobst
where    status = 1

return -999 /*SUCCESS*/
GO
GRANT EXECUTE ON  [dbo].[ujo_chk_running] TO [ujoadmin]
GO

Uses

[dbo].[ujo_jobst]
dbo