Can we specify timeout for a SQL server job?

30 Sep 2005 2:58 PM

Pushkar

Hi,

I have created a SQL Server job.
I want to know that wether I can specify a timeout value for the job, ie after running for some days that job should finish off.

Thanks in advance.
Pushkar

30 Sep 2005 3:40 PM

Jerry Spivey

Pushkar,

A job should almost never take "days" to finish. Having said that if the job cannot complete or fails the job will end and a failure entry will be written in the job history.

HTH

Jerry

"Pushkar" <pushkartiw***@gmail.com> wrote in message news:u9kH29cxFHA.3892@TK2MSFTNGP12.phx.gbl...
Hi,

I have created a SQL Server job.
I want to know that wether I can specify a timeout value for the job, ie after running for some days that job should finish off.

Thanks in advance.
Pushkar

4 Oct 2005 9:53 AM

Pushkar

Hi,

I have created a job which is supposed to run for ever.
How will it effect the SQL Server?

Is it good/bad to run such a job on production server?

Thanks
Pushkar

"Jerry Spivey" <jspi***@vestas-awt.com> wrote in message news:e8szEVdxFHA.2924@TK2MSFTNGP15.phx.gbl...
Pushkar,

A job should almost never take "days" to finish. Having said that if the job cannot complete or fails the job will end and a failure entry will be written in the job history.

HTH

Jerry

"Pushkar" <pushkartiw***@gmail.com> wrote in message news:u9kH29cxFHA.3892@TK2MSFTNGP12.phx.gbl...

    Hi,

    I have created a SQL Server job.
    I want to know that wether I can specify a timeout value for the job, ie after running for some days that job should finish off.

    Thanks in advance.
    Pushkar

30 Sep 2005 3:57 PM

Raymond D'Anjou

Are you talking about an expiration date for the job.
If so, you can specify an "end date" for the job in Enterprise manager.
If you prefer to use SQL, see sp_add_jobschedule or sp_update_jobschedule.

"Pushkar" <pushkartiw***@gmail.com> wrote in message news:u9kH29cxFHA.3892@TK2MSFTNGP12.phx.gbl...
Hi,

I have created a SQL Server job.
I want to know that wether I can specify a timeout value for the job, ie after running for some days that job should finish off.

Thanks in advance.
Pushkar

30 Sep 2005 3:58 PM

JT

If you go into Enterprise Manager and look at the Job Schedule dialog for a job, you will see there are fields for specifying a Start Date and optional End Date.

"Pushkar" <pushkartiw***@gmail.com> wrote in message news:u9kH29cxFHA.3892@TK2MSFTNGP12.phx.gbl...
Hi,

I have created a SQL Server job.
I want to know that wether I can specify a timeout value for the job, ie after running for some days that job should finish off.

Thanks in advance.
Pushkar