TSQL - ADmin
-
I would like to run schedule a SQL job running a a script to " exec sp_who " every 15 seconds using waitfor delay 00:15.
I would like to use SQL Scheduler or NT Scheduler. The output is very large.
How can I schedule the job to create a different file name with a time stamp every 2 -3 hours or how do I generate an output file for every 5 MB?
(UserID=2122
Select getdate ()
go
sp_who2
go
waitfor delay 00:00:15
go
Select getdate ()
go
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply