if object_Id( 'dbspRunCmd') Is Not Null
drop procedure dbspRunCmd
go

CREATE procedure dbspRunCmd
as
/*
*************************************************************
Name: dbspRunCmd
Description:

Usage:exec dbspRunCmd

Author: Steve Jones

Input Params:
-------------

Output Params:
--------------

Return:

Results:
---------

Locals:
--------
@err		Holds error value

Modifications:
--------------

*************************************************************
*/
set nocount on
declare @err int

select @err = 0
/*
Check parameters and exit if not correct.
*/
if @err = -1
begin
  Raiserror( 'Parameter Error:Usage:exec dbspRunCmd', 12, 1)
  return @err
end

declare cmd_curs cursor for
select DBA_AssistID, TSQLCode
  from DBA_Assist
  where compldt = '01/01/1900'
  order by InsDt

open cmd_curs
declare @code char( 250),
	 @id int

fetch next from cmd_curs into @id, @code
while @@fetch_status = 0
begin
  select @code
  exec( @code)
  update DBA_Assist
   set ComplDt = getdate()
   where DBA_AssistID = @id
  fetch next from cmd_curs into @id, @code
end
deallocate cmd_curs

return @err
GO
grant execute on dbspRunCmd to WebUser
go
if object_id( 'dbspRunCmd') Is Null
select 'dbspRunCmd Not Created'
else
select 'dbspRunCmd Created'
go