JOBS

Thanks for the help on this, when you go to the Locks/Object
section of Enterprise Manager, and click the drop down you
see the (said database in there, when you look at the
process's on the left hand screen, you have a ProcessID of
15, locktype = DB, Mode = U, Status = Grant, Owner = Sess
when you click for the properties of the process id, you
get the backup statement previously discussed, even though
the job that run's the script has finished and completed
sucessesfully, I'm afriad I cant go into any more detail
than that.
Sorry, PhilDid you try refreshing the screen? You can right click on the node above
the locks and choose "Refresh". See if that helps. Also run cp_locks in QA
and see if thoe locks still show up.
Andrew J. Kelly SQL MVP
"Phil" <anonymous@.discussions.microsoft.com> wrote in message
news:168201c3fbb8$02a5a430$a101280a@.phx.gbl...
> Thanks for the help on this, when you go to the Locks/Object
> section of Enterprise Manager, and click the drop down you
> see the (said database in there, when you look at the
> process's on the left hand screen, you have a ProcessID of
> 15, locktype = DB, Mode = U, Status = Grant, Owner = Sess
> when you click for the properties of the process id, you
> get the backup statement previously discussed, even though
> the job that run's the script has finished and completed
> sucessesfully, I'm afriad I cant go into any more detail
> than that.
> Sorry, Phil

job_id not found

Hi
I am getting a wierd message when I click on the SnapShot Agent.
Error 14262, The Specified @.job_id (###) does not exist
any idea what could have caused this and what I can do to resolve this
thanks
P
Has someone deleted the job using the management folder in EM? Have a look
in the jobs subfolder and see if the snapshot job has been removed or not.
If it has, then the easiest solution is to set up the publication once
again.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Job History hangs Enterprise Manager

Hi
I have Enterprise Manager on my local machine and administer a server from
it. When I go to jobs and right click and choose view job history I get an
hour glass and then EM Hangs and also pretty much kills my machine.
Has this happened to anyone else? Is there a reason and/or fix for it?
It only seems to happen on one server and I administer several others from
my machine with no problem. I am running SQL Server 2000 SP4
I have google but couldn't find anything helpfull.
ThanksHi
I am not sure about your particular problem you may want to use SQL Profiler
to check out what SQL it is running and/or run sp_help_jobhistory from Query
Analyser. If you have a very long job history you could run
sp_purge_jobhistory to remove it.
Other things you may want to do is to run DBCC CHECKDB on MSDB.
John
"Bri" wrote:
> Hi
> I have Enterprise Manager on my local machine and administer a server from
> it. When I go to jobs and right click and choose view job history I get an
> hour glass and then EM Hangs and also pretty much kills my machine.
> Has this happened to anyone else? Is there a reason and/or fix for it?
> It only seems to happen on one server and I administer several others from
> my machine with no problem. I am running SQL Server 2000 SP4
> I have google but couldn't find anything helpfull.
> Thanks
>|||Bri wrote:
> Hi
> I have Enterprise Manager on my local machine and administer a server from
> it. When I go to jobs and right click and choose view job history I get an
> hour glass and then EM Hangs and also pretty much kills my machine.
> Has this happened to anyone else? Is there a reason and/or fix for it?
> It only seems to happen on one server and I administer several others from
> my machine with no problem. I am running SQL Server 2000 SP4
> I have google but couldn't find anything helpfull.
> Thanks
>
When it "hangs", open up Query Analyzer and look at sysprocesses on the
server, see if there is something blocking you, or if there is a
waittype specified for your spid. You could just have an exceptionally
long history for the given job.

Job History

If you right click on job (in 2000) and do View History, Ent Mgr displays
(from what i can tell) only a certain number of lines. But I have a job that
runs every couple of minutes and I need to see much more history than that.
Is there somewhere this information is kept and is there a way I can change
the default on the number of history lines? Thx...
You should probably just query the DB. See MSDB.dbo.sysjobhistory
Ryan
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:BEC60862-A013-4509-80CD-2259731B5DEC@.microsoft.com...
> If you right click on job (in 2000) and do View History, Ent Mgr displays
> (from what i can tell) only a certain number of lines. But I have a job
that
> runs every couple of minutes and I need to see much more history than
that.
> Is there somewhere this information is kept and is there a way I can
change
> the default on the number of history lines? Thx...
|||Right click on the SQL Agent folder and choose properties. Then have a look
at the tabs and you will see a place to change the history retention
settings.
Andrew J. Kelly SQL MVP
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:BEC60862-A013-4509-80CD-2259731B5DEC@.microsoft.com...
> If you right click on job (in 2000) and do View History, Ent Mgr displays
> (from what i can tell) only a certain number of lines. But I have a job
> that
> runs every couple of minutes and I need to see much more history than
> that.
> Is there somewhere this information is kept and is there a way I can
> change
> the default on the number of history lines? Thx...

Job History

If you right click on job (in 2000) and do View History, Ent Mgr displays
(from what i can tell) only a certain number of lines. But I have a job tha
t
runs every couple of minutes and I need to see much more history than that.
Is there somewhere this information is kept and is there a way I can change
the default on the number of history lines? Thx...You should probably just query the DB. See MSDB.dbo.sysjobhistory
Ryan
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:BEC60862-A013-4509-80CD-2259731B5DEC@.microsoft.com...
> If you right click on job (in 2000) and do View History, Ent Mgr displays
> (from what i can tell) only a certain number of lines. But I have a job
that
> runs every couple of minutes and I need to see much more history than
that.
> Is there somewhere this information is kept and is there a way I can
change
> the default on the number of history lines? Thx...|||Right click on the SQL Agent folder and choose properties. Then have a look
at the tabs and you will see a place to change the history retention
settings.
Andrew J. Kelly SQL MVP
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:BEC60862-A013-4509-80CD-2259731B5DEC@.microsoft.com...
> If you right click on job (in 2000) and do View History, Ent Mgr displays
> (from what i can tell) only a certain number of lines. But I have a job
> that
> runs every couple of minutes and I need to see much more history than
> that.
> Is there somewhere this information is kept and is there a way I can
> change
> the default on the number of history lines? Thx...

Job History

If you right click on job (in 2000) and do View History, Ent Mgr displays
(from what i can tell) only a certain number of lines. But I have a job that
runs every couple of minutes and I need to see much more history than that.
Is there somewhere this information is kept and is there a way I can change
the default on the number of history lines? Thx...You should probably just query the DB. See MSDB.dbo.sysjobhistory
Ryan
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:BEC60862-A013-4509-80CD-2259731B5DEC@.microsoft.com...
> If you right click on job (in 2000) and do View History, Ent Mgr displays
> (from what i can tell) only a certain number of lines. But I have a job
that
> runs every couple of minutes and I need to see much more history than
that.
> Is there somewhere this information is kept and is there a way I can
change
> the default on the number of history lines? Thx...|||Right click on the SQL Agent folder and choose properties. Then have a look
at the tabs and you will see a place to change the history retention
settings.
--
Andrew J. Kelly SQL MVP
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:BEC60862-A013-4509-80CD-2259731B5DEC@.microsoft.com...
> If you right click on job (in 2000) and do View History, Ent Mgr displays
> (from what i can tell) only a certain number of lines. But I have a job
> that
> runs every couple of minutes and I need to see much more history than
> that.
> Is there somewhere this information is kept and is there a way I can
> change
> the default on the number of history lines? Thx...