sql server agent jobs history

Question

Hi Team,

SQL SERVER Agent jobs subplan_1,Plan_2, Plan_3 .. Etc i m not able see jobs history could you please suggest how can we see the history?

sqlagent-->properties-->History  log size = 1000 and Job history rows per job =100 but  i m not able to see subplan job history please suggest where can changed any thing.

Tx

---

subu

Answer 1

Hi,

Those look like jobs from a maintenance plan. You can right click on the plan itself and look at the history there.

Seth

---

http://lqqsql.wordpress.com

Answer 2

I agree with Seth, maint plan history is more refined than job history (for maint jobs). However, there should be job history as well. My guess is that you reached the limit of 1000 rows for other jobs causing this history to be removed. I always up 1000 to 10000 or more just for this to no happen.

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 3

Hi Team,

As per your suggestion i have seen mainttaince plan history but in some situvsaction we need to see the subplan histoy some long back how can we do this.

and more over job history also not appearing at least single row also please suggest me where can i change

Please find the below attachment.

---

subu

Answer 4

Hi Subu,

Can you open and check log file from disk? The path of log file should be like - ...\Program Files\Microsoft SQL Server\MSSQL10_50.Instance\MSSQL\Log. Or you can check your settings from 'Configuration Manager' --> SQL Agent--> Properties--> Advance.

-Nishad

Answer 5

hi subbu

check this url to get detail

http://pulse.sqlserverpedia.com/blog/sysjobhistory-outliers/

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 6

Did you change the max number of rows setting from 1000 to 10000, 20000 or some other more suitable value?

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 7

Tibork

i did as per your suggestion but no luck/

 Babu

I m exectuing that sps in our environment we will check the status.

Tx

---

subu