Mark Forums Read

Job Agent

Go Back

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Reply

Page 1 of 2

1

#1

Old

Jay Bukstein

Posts: n/a

Job Agent - 05-14-2008 , 03:57 PM

I have maintenance job the runs a Reorganize/rebuild indexes. It normallly
takes 90minutes to do all DB's but on occassion it gets hung up. The job
starts at 10pm, is there a way to check if it's still running at 12:00pm and
if it is notify on of the DBA's?

Reply With Quote

#2

Old

Andrew J. Kelly

Posts: n/a

Re: Job Agent - 05-14-2008 , 04:52 PM

You can create another job that periodically checks the status with
sp_helpjob and act accordingly. A product from www.sqlsentry.net will also
handle this and more.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Jay Bukstein" <JayBukstein (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have maintenance job the runs a Reorganize/rebuild indexes. It normallly
takes 90minutes to do all DB's but on occassion it gets hung up. The job
starts at 10pm, is there a way to check if it's still running at 12:00pm
and
if it is notify on of the DBA's?

Reply With Quote

#3

Old

Andrew J. Kelly

Posts: n/a

Re: Job Agent - 05-14-2008 , 04:52 PM

You can create another job that periodically checks the status with
sp_helpjob and act accordingly. A product from www.sqlsentry.net will also
handle this and more.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Jay Bukstein" <JayBukstein (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have maintenance job the runs a Reorganize/rebuild indexes. It normallly
takes 90minutes to do all DB's but on occassion it gets hung up. The job
starts at 10pm, is there a way to check if it's still running at 12:00pm
and
if it is notify on of the DBA's?

Reply With Quote

#4

Old

Andrew J. Kelly

Posts: n/a

Re: Job Agent - 05-14-2008 , 04:52 PM

You can create another job that periodically checks the status with
sp_helpjob and act accordingly. A product from www.sqlsentry.net will also
handle this and more.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Jay Bukstein" <JayBukstein (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have maintenance job the runs a Reorganize/rebuild indexes. It normallly
takes 90minutes to do all DB's but on occassion it gets hung up. The job
starts at 10pm, is there a way to check if it's still running at 12:00pm
and
if it is notify on of the DBA's?

Reply With Quote

#5

Old

Andrew J. Kelly

Posts: n/a

Re: Job Agent - 05-14-2008 , 04:52 PM

You can create another job that periodically checks the status with
sp_helpjob and act accordingly. A product from www.sqlsentry.net will also
handle this and more.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Jay Bukstein" <JayBukstein (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have maintenance job the runs a Reorganize/rebuild indexes. It normallly
takes 90minutes to do all DB's but on occassion it gets hung up. The job
starts at 10pm, is there a way to check if it's still running at 12:00pm
and
if it is notify on of the DBA's?

Reply With Quote

#6

Old

Andrew J. Kelly

Posts: n/a

Re: Job Agent - 05-14-2008 , 04:52 PM

You can create another job that periodically checks the status with
sp_helpjob and act accordingly. A product from www.sqlsentry.net will also
handle this and more.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Jay Bukstein" <JayBukstein (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have maintenance job the runs a Reorganize/rebuild indexes. It normallly
takes 90minutes to do all DB's but on occassion it gets hung up. The job
starts at 10pm, is there a way to check if it's still running at 12:00pm
and
if it is notify on of the DBA's?

Reply With Quote

#7

Old

Andrew J. Kelly

Posts: n/a

Re: Job Agent - 05-14-2008 , 04:52 PM

You can create another job that periodically checks the status with
sp_helpjob and act accordingly. A product from www.sqlsentry.net will also
handle this and more.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Jay Bukstein" <JayBukstein (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have maintenance job the runs a Reorganize/rebuild indexes. It normallly
takes 90minutes to do all DB's but on occassion it gets hung up. The job
starts at 10pm, is there a way to check if it's still running at 12:00pm
and
if it is notify on of the DBA's?

Reply With Quote

#8

Old

Andrew J. Kelly

Posts: n/a

Re: Job Agent - 05-14-2008 , 04:52 PM

You can create another job that periodically checks the status with
sp_helpjob and act accordingly. A product from www.sqlsentry.net will also
handle this and more.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Jay Bukstein" <JayBukstein (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have maintenance job the runs a Reorganize/rebuild indexes. It normallly
takes 90minutes to do all DB's but on occassion it gets hung up. The job
starts at 10pm, is there a way to check if it's still running at 12:00pm
and
if it is notify on of the DBA's?

Reply With Quote

#9

Old

Andrew J. Kelly

Posts: n/a

Re: Job Agent - 05-14-2008 , 04:52 PM

You can create another job that periodically checks the status with
sp_helpjob and act accordingly. A product from www.sqlsentry.net will also
handle this and more.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Jay Bukstein" <JayBukstein (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have maintenance job the runs a Reorganize/rebuild indexes. It normallly
takes 90minutes to do all DB's but on occassion it gets hung up. The job
starts at 10pm, is there a way to check if it's still running at 12:00pm
and
if it is notify on of the DBA's?

Reply With Quote

#10

Old

Andrew J. Kelly

Posts: n/a

Re: Job Agent - 05-14-2008 , 04:52 PM

You can create another job that periodically checks the status with
sp_helpjob and act accordingly. A product from www.sqlsentry.net will also
handle this and more.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Jay Bukstein" <JayBukstein (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have maintenance job the runs a Reorganize/rebuild indexes. It normallly
takes 90minutes to do all DB's but on occassion it gets hung up. The job
starts at 10pm, is there a way to check if it's still running at 12:00pm
and
if it is notify on of the DBA's?

Reply With Quote

Reply

Page 1 of 2

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.