| Author |
Topic |
|
ssrikrish
Yak Posting Veteran
69 Posts |
 Posted - 2005-07-24 : 22:41:02
|
| hi,I ran into a weird situation which I have never seen happen before. The SQL server agent scheduled jobs have been running successfully on the server but the last job run status are not being updated with the latest date/time it ran. It still shows a date that is one month old. I know for sure that it has been running because the nightly backups are coming through properly which is one of the scheduled jobs. and none of the jobs failed.Any input is appreciated.Thanks,sri |
|
|
ssrikrish
Yak Posting Veteran
69 Posts |
Posted - 2005-07-25 : 22:31:46
|
| To add on to the issue in question, today I dropped the job and recreated it but still the last run status is not being updated. Is it some SQL server setting that I need to run on? It has been working fine since june 12th or so. Nothing changed since that. Hence I am bamboozled here.Help needed please.Thanks,sri |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-07-25 : 23:52:47
|
| this happened to me before, checking the connection settings on the sql server agent in enterprise manager, showed me that the user was changed, correcting it did the trickwe might have the same scenario, it's worth the check though--------------------keeping it simple... |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-07-26 : 16:58:55
|
| maybe the dates on all systems involved on process...Igor. |
|
|
|
ssrikrish
Yak Posting Veteran
69 Posts |
Posted - 2005-07-26 : 17:02:35
|
| Thanks for the responses but apparently it still does not work. The system date and time reflects properly. No problem there. I also checked the connection properties. It runs using Windows authentication under a particular account. Nothing changed there. It is not running under SQL server authentication. Thanks,sri |
|
|
|
ssrikrish
Yak Posting Veteran
69 Posts |
Posted - 2005-07-30 : 08:58:45
|
| Team,I asked a Microsoft SQL server Tech support person and he couldn't help me either. Everyone says that they haven't run into this issue. Yikes..I have created output files for the time being to which it writes the step history. At least, I will know that the jobs are running. But guess what, even the output file does not show me the job completion date and time. It does show the job start date and time. I would really appreciate more responses to this issue.sri |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-07-30 : 10:36:15
|
| What does it say in the sysjobhistory table (msdb database),that is where the run history of the jobs are recorded.rockmoose |
|
|
|
ssrikrish
Yak Posting Veteran
69 Posts |
Posted - 2005-07-30 : 16:52:17
|
| I checked that sysjobhistory table already. No history is being recorded. The last time the history was recorded was from june but the jobs run daily. --sri |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-07-30 : 17:22:02
|
| If You create a new "dummy" job and run it, it doesn't create any entries in sysjobhistory ?If You do this and run it, use profiler to catch any sql traffic to see exactly what is (what is not) happening.rockmoose |
|
|
|
ssrikrish
Yak Posting Veteran
69 Posts |
Posted - 2005-07-30 : 20:27:20
|
| I have done that too. When I run the job, it does not create any row in sysjobhistory. Profiler showed that the process is kicking off. I saw the sql traffic due to the job. It is kind of very strange. Do you think it may be a bug in sql server?--sri |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-07-31 : 05:53:21
|
| If You run this:EXEC master.dbo.xp_sqlagent_enum_jobs 1, ''It will show You a resultset with information on the jobs,Do the columns: [Last Run Date], [Last Run Time] show the correct date ?In the msdb database there is a view: sysjobs_viewWhen SQL Server retrieves info for the jobs, it goes through that view, It has some security privilege checks(very basic, You can look at the DDL of the view Yourself)If You use the same windows account as Sql Server Agent and select from sysjobs_view, does that retrieve all the jobs ?,or is there a security glitch ?rockmoose |
|
|
|
|
SQL server Agent Last Run job status