Read about JOBS in the Books Online.
MCSE, SQL Server MCT, MVP
Feed Someone for Free Today!
Quote:> I have a stored Procedure that will take a long time to run.
> So I need a sql Statment that I can start The procedure and not wait for
> responce. I don't care when the Process Finishes. I just want to have
> something start it and then return.
If someone can write an easier way, please let me know!!!.
What I would like to do is read particular table names from sysobjects
and using sp_spaceused, populate the table TmpTblSpaceUsed.
I'd rather not have to open a cursor and was wondering if I could do
this using only a couple of lines.
PS. Is there also an easy way to convert the varchar(18) eg '18 KB'
results from sp_spaceused to a numeric value ... eg 18
CREATE TABLE #TmpTblSpaceUsed
nrows int default 0,
sysobjects.id > 50099219 '
Sent via Deja.com http://www.deja.com/
Before you buy.