Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lioracle
Starting Member
2 Posts |
 Posted - 2008-06-24 : 06:08:53
|
| hello. i have job (not maintence plan). when i "right click" + "view history" i didnt see job history how can i add him "job history"thanks |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-06-24 : 07:21:41
|
| helloexecute that job first and when it gets executed then check the history. |
 |
|
|
lioracle
Starting Member
2 Posts |
Posted - 2008-06-24 : 08:54:17
|
| i do it and when i click view history i get message - "no history" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-24 : 10:18:20
|
quote:
Originally posted by lioracle
i do it and when i click view history i get message - "no history"
Did you refresh job? Check in jobhistory table in MSDB database. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-24 : 23:18:11
|
| Did job ever run? |
|
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-06-25 : 02:06:42
|
| u can check in the sysjobs table:select name from msdb..sysjobsand if the job exists then u can check its hsitory asselect a.run_status,a.run_date,a.message,b.name from msdb..sysjobhistory a , msdb..sysjobs b where a.job_id=b.job_id and step_id =0 and (run_date = convert(varchar,getdate(),112) or run_date =convert(varchar,getdate()-1,112)) |
|
|
|
|
|
|
job without job history.