|
ramu143
Yak Posting Veteran
64 Posts |
 Posted - 09/27/2008 : 02:08:37
|
Posted - 09/27/2008 : 00:18:18
--------------------------------------------------------------------------------
i have created one procedure name mohan
i want to job shedule this one out put is 5 columns very rare we are getting out put are we are gettig 0 rows effected
the procedure is like below please modify this one if need and tell me how to job schedule this one.
CREATE procedure MOHAN
as
begin
insert into cdb (machineid,operatorout,devbname,minutes,noofcalls,ACD)
select machineid,operatorout,devbname,minutes,noofcalls,(minutes*1.0/noofcalls) as ACD
from
(
select machineid,operatorout,devbname,sum(talktime)/60 as minutes,count(*) as noofcalls from wholesale.margin.dbo.cdb
where operatorout not like '%_in' and connectflag='1' and devbname like 'dac%' group by machineid,operatorout,devbname
)t
order by machineid,operatorout,devbname
select * from CDB where ACD<1 and noofcalls>30 order by ACD ,noofcalls--- THIS IS THE OUT PUT I NEED TO GET IN JOB SHEDULE>
end
GO
|
|
please help me for this Sp
