x

How to know job when statred when completed and how much time it is running?

Maintainance plane Job was failed for one database... Need to check how much time the job is running? Actually that is in restricted growth and we increased the maxsize to that file but

Need to know why that job failed and what are the steps we have what happend to that database?
more ▼

asked Nov 22, 2011 at 01:49 AM in Default

Naren gravatar image

Naren
27 17 18 19

So far you have asked 9 questions on this forum and have had 13 answers but have not marked any of them as having helped you. This wont encourage people to keep offering solutions to questions you pose. Would you be able to find some time to review the answers that you have had on other questions and mark appropriate one as helpful by clicking the tick beside them please? It isnt much to ask for all the assistance that is offered across this site.

Thanks
Nov 22, 2011 at 01:59 AM Fatherjack ♦♦

@Naren, You must consider Mr. Fatherjack's suggestion. Hope you do that.

After the anticipation, can you please clarify this statement in your question "we increased the maxsize to that file but". Your question is quite ambiguous and you should add more details. As far as job running time is concerned, it is very easy, you can find it out in msdb.dbo.sysjobhistory table. I am not giving it as an answer, because I think your question is something else which you were not able to portray.
Nov 22, 2011 at 02:11 AM Usman Butt
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
You can check the status of the failed job in View History option from the job's list . Same way in Maintenence Plan you can heck the view history option .
more ▼

answered Nov 22, 2011 at 02:25 AM

jhunu gravatar image

jhunu
90 29 30 31

(comments are locked)
10|1200 characters needed characters left

There are two possible places for errors, the SQL Server error log may have information about the failure. This is found under the Server Objects folder in Object Explorer.

You also may see errors in the SQL Agent error log. This is found under the SQL Agent folder in the Object Explorer.

Also, you can modify your jobs to provide an output file. This will contain a lot more detail if things go wrong to help you understand what happened. This is available on the Advanced paged of each Job Step.
more ▼

answered Nov 22, 2011 at 03:48 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
101k 19 21 74

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1949
x84

asked: Nov 22, 2011 at 01:49 AM

Seen: 1430 times

Last Updated: Nov 22, 2011 at 01:49 AM