You could code your own 'scheduler' stored procedure to run an infinite loop with a 5 second wait between calls to your 'scheduled' procedure. Use the T-SQL statement WAITFOR to do this.

thnaks for u r healp. It will make more sense if u send tsql query.

thanks
Vamsi.

vamsi

You will learn more if you figure it out!
Hint: use the SQL Server Books Online to find out about WAITFOR and WHILE.

abob.. great tip.. didn't know that existed.... :)

-- TSQL

WHILE(1=1)
BEGIN
    WAITFOR DELAY '00:00:05'
    EXEC SP_PrintDate
END

i used this code for the scheduler.



vamsi