Post reply

Create Job to run indefinitely

  • June 6, 2013 at 6:59 am

    #294151

    Hi experts,

    Can anyone please help me create a job that should run indefinitely i mean the the script should keep on running.

    Thanks in Advance

  • June 6, 2013 at 7:04 am

    #1621719

    Ratheesh.K.Nair (6/6/2013)

    Hi experts,

    Can anyone please help me create a job that should run indefinitely i mean the the script should keep on running.

    Thanks in Advance

    have you created a job at all yet? do you really mean you want the script to run every x minutes? you can create a procedure which never exits, but i doubt that's what you want;

    typically you create something that does something, and finishes, but you want it to keep checking every 5 minutes or something; for example checking if someone put in a password change/reminder request, and sending them out in batches every minute.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 6, 2013 at 7:18 am

    #1621724

    Thanks Lowell,

    I want the process to keep running. Creating a recurring job wont help me.

    Since am trying on test server DBCC CHECKDB wont take more than few seconds.

  • June 6, 2013 at 7:29 am

    #1621732

    Ratheesh.K.Nair (6/6/2013)

    Thanks Lowell,

    I want the process to keep running. Creating a recurring job wont help me.

    Since am trying on test server DBCC CHECKDB wont take more than few seconds.

    i think you missed the point.

    you said DBCC CHECKDB takes a few seconds and completes.

    if you want it to run "all the time", you really are saying "i want this to run over and over again", right?

    that's exactly what a job with a recurring schedule does.

    maybe you need to provide more details than you have done so far? you typically never need to run DBCC CHECKDB more than once a day, unless you are really seeing some hardware problems,and are trying to track it down...in that case, yeah maybe you want to call the method over and over until you get error results?

    My friend Gianluca Sartori @SSC has a nice notification-of-problems version of CheckDB you might be interested in; he's posted this in several other forum posts:

    http://spaghettidba.com/2013/02/27/dba_runcheckdb-v2012/

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 6, 2013 at 8:17 am

    #1621759

    Thanks Lowell and thanks again for the Link

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply