Scheduled job with @active_start_time AFTER @active_end_time

What happens if we have a scheduled job with the @.active_start_time is
BEFORE @.active_end_Time
As far as I can see from the online docuementation the only requirement
is that they be not equal.
Can anyone shed light on this ?
cheers,
Senthil
Sorry, as the subject says (if the active_start_time is AFTER
@.active_end_time)
and not before (which is the normal case) as I say below
jayneandkumar@.gmail.com wrote:
> What happens if we have a scheduled job with the @.active_start_time is
> BEFORE @.active_end_Time
> As far as I can see from the online docuementation the only requirement
> is that they be not equal.
> Can anyone shed light on this ?
> cheers,
> Senthil

Scheduled job with @active_start_time AFTER @active_end_time

What happens if we have a scheduled job with the @.active_start_time is
BEFORE @.active_end_Time
As far as I can see from the online docuementation the only requirement
is that they be not equal.
Can anyone shed light on this ?
cheers,
SenthilSorry, as the subject says (if the active_start_time is AFTER
@.active_end_time)
and not before (which is the normal case) as I say below
jayneandkumar@.gmail.com wrote:
> What happens if we have a scheduled job with the @.active_start_time is
> BEFORE @.active_end_Time
> As far as I can see from the online docuementation the only requirement
> is that they be not equal.
> Can anyone shed light on this ?
> cheers,
> Senthil

Scheduled job with @active_start_time AFTER @active_end_time

What happens if we have a scheduled job with the @.active_start_time is
BEFORE @.active_end_Time
As far as I can see from the online docuementation the only requirement
is that they be not equal.
Can anyone shed light on this ?
cheers,
SenthilSorry, as the subject says (if the active_start_time is AFTER
@.active_end_time)
and not before (which is the normal case) as I say below
jayneandkumar@.gmail.com wrote:
> What happens if we have a scheduled job with the @.active_start_time is
> BEFORE @.active_end_Time
> As far as I can see from the online docuementation the only requirement
> is that they be not equal.
> Can anyone shed light on this ?
> cheers,
> Senthil

scheduled delete performance cost

What would be the performance cost if I deleted all the rows from a table in MSSQL every 5 minutes?

I'm doing this to keep track of whos online. Every time a user goes to a new page they get logged into a table called WhosOnline. Every 5 minutes the log will get deleted.

What would be the performance cost of this and if its high, does anyone know a better way to keep track of whos Online?Forget it, I figured out how to do it. SessionID & UserName in a database.

schedule a trace

Can someone share an example of how to schedule a trace? I have seen some stuff online that used xp_trace extended procedures however examples are not detailed enough for me to create a script of my own. So if someone can help me with their knowledge that will be great.

thanks

See SQL Server 2005 Books Online topics:
Scheduling Traces
http://msdn2.microsoft.com/en-us/library/ms187656.aspx

Using SQL Trace
http://msdn2.microsoft.com/en-us/library/ms191443.aspx