Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

what is the effect of job category Expand / Collapse
Author
Message
Posted Wednesday, October 06, 2010 6:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 08, 2011 4:49 PM
Points: 4, Visits: 28
Hi
what is the different if i make my sqlserver agent job as a realtime or daemon or uncategorized in sq 2000?

if i have the job runs every 1 hour so is realtime will force the job to exit if it runs for more than 1 hour?

Thanks in advance
Post #1000079
Posted Wednesday, October 06, 2010 10:39 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, January 30, 2014 8:52 AM
Points: 1,618, Visits: 20,966
Job Categories help you organize the jobs for easy management. They do not have any impact on the job execution.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #1000116
Posted Thursday, October 07, 2010 1:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 08, 2011 4:49 PM
Points: 4, Visits: 28
very useful info , i did not find it anywhere !
thank you
Post #1000153
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse