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 |
|
vikky
Yak Posting Veteran
54 Posts |
 Posted - 2011-11-22 : 01:55:41
|
| Hi,I am using sql server 2005 express edition.In my server some jobs are executed daily. But those jobs history is not available in MSDB..SysJobHistory and MSDB..SysJobs.Please help where jobs history information is maintained. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-22 : 03:16:57
|
| didnt understand how you execute jobs in sql server express as it doesnt have sql agent available in it by default for creating and scheduling jobs.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
vikky
Yak Posting Veteran
54 Posts |
Posted - 2011-11-22 : 04:06:05
|
| We are executing the jobs through 3rd party tool. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-22 : 04:16:08
|
quote:
Originally posted by vikky
We are executing the jobs through 3rd party tool.
then how do you think you will have information in MSDB..SysJobHistory and MSDB..SysJobs for these jobs?These tables are actually used by sql server agent for storing job information created inside them------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
vikky
Yak Posting Veteran
54 Posts |
Posted - 2011-11-22 : 04:27:14
|
| ok, Please explain the solution to how to get the given job last execution datetime. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-22 : 04:39:21
|
quote:
Originally posted by vikky
ok, Please explain the solution to how to get the given job last execution datetime.
No idea until we know what 3rd party tool you're using and its features like whether it will do logging, if yes, what are different options etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Hi, Please help. It's Urgent.