Jobs

Hi,
Using Enterprise Manager, when i create a job, The job properties dialog box
has Schedules tab. In Schedules tab I have option to create New Altert.
I am trying to undrestand why would i need to create an alert in Job
Schadules.
Any help would be apprecited,
AliHi,
By setting an alert on a job, you can send a Email / Pager message to get
the status of your job.
Thanks
Hari
MCDBA
"A.M" <IHateSpam@.sapm123.com> wrote in message
news:eZuJTct3DHA.4060@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Hi,
> Using Enterprise Manager, when i create a job, The job properties dialog

---

box

quote:

---

> has Schedules tab. In Schedules tab I have option to create New Altert.
> I am trying to undrestand why would i need to create an alert in Job
> Schadules.
> Any help would be apprecited,
> Ali
>

---

|||Hi Ali,
Thank you for using MSDN Newsgroup!
I would like to follow up on this issue and see if you still have questions
about this issue. Should you have any questions, please feel free to post
here. Looking forward to your reply!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

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 Step Set up

I am creating a job within Enterprise Manager on SQL 2K to backup a database called Messaging. In creating the step, on the General tab there are four fields: Step name, Type, Database, Command.
My Command is:
BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD , NAME = N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
In relation to the above command, do I select Messaging from the database drop down list?
In relation to the above command, if Master is selected from the database drop down list, what is backed up, Master or Messaging?
Message posted via http://www.sqlmonster.com
You can select messaging if you want but you do not have to. This listbox
just tells the SQL Server job agent which database to execute the T-SQL
within. Since you are telling SQL Server to backup the messaging database
("BACKUP DATABASE Messaging") you do not have to select the database.
Either way the messaging database will be backed up.
Personally I would leave the database listbox set to master.
Keith
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:0feb5d1e2fea4bc386ad965ac4d66991@.SQLMonster.c om...
> I am creating a job within Enterprise Manager on SQL 2K to backup a
database called Messaging. In creating the step, on the General tab there
are four fields: Step name, Type, Database, Command.
> My Command is:
> BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD ,
NAME = N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
> In relation to the above command, do I select Messaging from the database
drop down list?
> In relation to the above command, if Master is selected from the database
drop down list, what is backed up, Master or Messaging?
> --
> Message posted via http://www.sqlmonster.com

Job Step Set up

I am creating a job within Enterprise Manager on SQL 2K to backup a database
called Messaging. In creating the step, on the General tab there are four f
ields: Step name, Type, Database, Command.
My Command is:
BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD , NAME
= N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
In relation to the above command, do I select Messaging from the database dr
op down list?
In relation to the above command, if Master is selected from the database dr
op down list, what is backed up, Master or Messaging?
Message posted via http://www.droptable.comYou can select messaging if you want but you do not have to. This listbox
just tells the SQL Server job agent which database to execute the T-SQL
within. Since you are telling SQL Server to backup the messaging database
("BACKUP DATABASE Messaging") you do not have to select the database.
Either way the messaging database will be backed up.
Personally I would leave the database listbox set to master.
Keith
"Robert Richards via droptable.com" <forum@.droptable.com> wrote in message
news:0feb5d1e2fea4bc386ad965ac4d66991@.SQ
droptable.com...
> I am creating a job within Enterprise Manager on SQL 2K to backup a
database called Messaging. In creating the step, on the General tab there
are four fields: Step name, Type, Database, Command.
> My Command is:
> BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD ,
NAME = N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
> In relation to the above command, do I select Messaging from the database
drop down list?
> In relation to the above command, if Master is selected from the database
drop down list, what is backed up, Master or Messaging?
> --
> Message posted via http://www.droptable.comsql

Job Step Set up

I am creating a job within Enterprise Manager on SQL 2K to backup a database called Messaging. In creating the step, on the General tab there are four fields: Step name, Type, Database, Command.
My Command is:
BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD , NAME = N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
In relation to the above command, do I select Messaging from the database drop down list?
In relation to the above command, if Master is selected from the database drop down list, what is backed up, Master or Messaging?
--
Message posted via http://www.sqlmonster.comYou can select messaging if you want but you do not have to. This listbox
just tells the SQL Server job agent which database to execute the T-SQL
within. Since you are telling SQL Server to backup the messaging database
("BACKUP DATABASE Messaging") you do not have to select the database.
Either way the messaging database will be backed up.
Personally I would leave the database listbox set to master.
--
Keith
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:0feb5d1e2fea4bc386ad965ac4d66991@.SQLMonster.com...
> I am creating a job within Enterprise Manager on SQL 2K to backup a
database called Messaging. In creating the step, on the General tab there
are four fields: Step name, Type, Database, Command.
> My Command is:
> BACKUP DATABASE Messaging TO Messaging20050114 WITH NOINIT , NOUNLOAD ,
NAME = N'Messaging Full Backup', NOSKIP , STATS = 10, NOFORMAT
> In relation to the above command, do I select Messaging from the database
drop down list?
> In relation to the above command, if Master is selected from the database
drop down list, what is backed up, Master or Messaging?
> --
> Message posted via http://www.sqlmonster.com

Job Step command altering

Is their a way to alter a job step command using T-SQL rather than using
the GUI in enterprise manager?
For example, if I have an existing command of:
BACKUP DATABASE [CE90] TO Disk = 'CE90_20050118.bak' WITH NOINIT ,
NOUNLOAD , NAME = N'CE90 Full Backup', NOSKIP , STATS = 10, NOFORMAT
Is it possible to alter the above command to a different disk device using
T-SQL?
--
Message posted via http://www.sqlmonster.comYou an use sp_update_jobstep. You can find more information
on this stored procedure in books online.
-Sue
On Wed, 02 Feb 2005 19:25:39 GMT, "Robert Richards via
SQLMonster.com" <forum@.SQLMonster.com> wrote:
>Is their a way to alter a job step command using T-SQL rather than using
>the GUI in enterprise manager?
>For example, if I have an existing command of:
>BACKUP DATABASE [CE90] TO Disk = 'CE90_20050118.bak' WITH NOINIT ,
>NOUNLOAD , NAME = N'CE90 Full Backup', NOSKIP , STATS = 10, NOFORMAT
>Is it possible to alter the above command to a different disk device using
>T-SQL?

Job Status Wrong

Hello,
In my Enterprise Manager i see one job that i know its running(i look
locally on server) and jobs status appear like job is not executing(job
status is wrong)
Is there any patch to apply to EM?
Thanks and best regards.
Hi
I take it that by wrong status, you mean it is showing as sleeping under
current activity in Enterprise Manager. This is quiet normal as Sql Server
pages in and out processes as it runs them. If you keep refreshing it you may
catch it as active.
If you want to check that it is actually doing something, you can monitor it
with profiler or if you double click on the current activity, you get details
of the current SQL statement being performed. If you refresh that you should
see it change.
Hope this helps
John
"CC&JM" wrote:

> Hello,
> In my Enterprise Manager i see one job that i know its running(i look
> locally on server) and jobs status appear like job is not executing(job
> status is wrong)
> Is there any patch to apply to EM?
> Thanks and best regards.
|||Hello John,
Thanks for your answer, now i see the status of the job quit well but
yesterday i had a job that runs 4 example at 10:00 12:00 14:00 and so on..
and at 18:00 when i look at EM "Last Run Status" showed 10:00 and "Next Run
Date" showed 12:00.
I know that the problem was with my EM because in the EM of my partner i saw
the job status normally.
Thanks John,
Best regards
"John Bandettini" wrote:
[vbcol=seagreen]
> Hi
> I take it that by wrong status, you mean it is showing as sleeping under
> current activity in Enterprise Manager. This is quiet normal as Sql Server
> pages in and out processes as it runs them. If you keep refreshing it you may
> catch it as active.
> If you want to check that it is actually doing something, you can monitor it
> with profiler or if you double click on the current activity, you get details
> of the current SQL statement being performed. If you refresh that you should
> see it change.
> Hope this helps
> John
> "CC&JM" wrote:
|||Hi
I misunderstood your problem, I thought you were looking at current
activity. If you were looking at jobs and the job did not seem to be running,
did you refresh the display? Once you have opened something in Enterprise
manager, like jobs it will not automatically refresh. You need to either
right click and choose refresh or press F5.
Regards
John
"CC&JM" wrote:
[vbcol=seagreen]
> Hello John,
> Thanks for your answer, now i see the status of the job quit well but
> yesterday i had a job that runs 4 example at 10:00 12:00 14:00 and so on..
> and at 18:00 when i look at EM "Last Run Status" showed 10:00 and "Next Run
> Date" showed 12:00.
> I know that the problem was with my EM because in the EM of my partner i saw
> the job status normally.
> Thanks John,
> Best regards
> "John Bandettini" wrote:
sql

Job Status Wrong

Hello,
In my Enterprise Manager i see one job that i know its running(i look
locally on server) and jobs status appear like job is not executing(job
status is wrong)
Is there any patch to apply to EM?
Thanks and best regards.Hi
I take it that by wrong status, you mean it is showing as sleeping under
current activity in Enterprise Manager. This is quiet normal as Sql Server
pages in and out processes as it runs them. If you keep refreshing it you may
catch it as active.
If you want to check that it is actually doing something, you can monitor it
with profiler or if you double click on the current activity, you get details
of the current SQL statement being performed. If you refresh that you should
see it change.
Hope this helps
John
"CC&JM" wrote:
> Hello,
> In my Enterprise Manager i see one job that i know its running(i look
> locally on server) and jobs status appear like job is not executing(job
> status is wrong)
> Is there any patch to apply to EM?
> Thanks and best regards.|||Hello John,
Thanks for your answer, now i see the status of the job quit well but
yesterday i had a job that runs 4 example at 10:00 12:00 14:00 and so on..
and at 18:00 when i look at EM "Last Run Status" showed 10:00 and "Next Run
Date" showed 12:00.
I know that the problem was with my EM because in the EM of my partner i saw
the job status normally.
Thanks John,
Best regards
"John Bandettini" wrote:
> Hi
> I take it that by wrong status, you mean it is showing as sleeping under
> current activity in Enterprise Manager. This is quiet normal as Sql Server
> pages in and out processes as it runs them. If you keep refreshing it you may
> catch it as active.
> If you want to check that it is actually doing something, you can monitor it
> with profiler or if you double click on the current activity, you get details
> of the current SQL statement being performed. If you refresh that you should
> see it change.
> Hope this helps
> John
> "CC&JM" wrote:
> > Hello,
> >
> > In my Enterprise Manager i see one job that i know its running(i look
> > locally on server) and jobs status appear like job is not executing(job
> > status is wrong)
> > Is there any patch to apply to EM?
> >
> > Thanks and best regards.|||Hi
I misunderstood your problem, I thought you were looking at current
activity. If you were looking at jobs and the job did not seem to be running,
did you refresh the display? Once you have opened something in Enterprise
manager, like jobs it will not automatically refresh. You need to either
right click and choose refresh or press F5.
Regards
John
"CC&JM" wrote:
> Hello John,
> Thanks for your answer, now i see the status of the job quit well but
> yesterday i had a job that runs 4 example at 10:00 12:00 14:00 and so on..
> and at 18:00 when i look at EM "Last Run Status" showed 10:00 and "Next Run
> Date" showed 12:00.
> I know that the problem was with my EM because in the EM of my partner i saw
> the job status normally.
> Thanks John,
> Best regards
> "John Bandettini" wrote:
> > Hi
> >
> > I take it that by wrong status, you mean it is showing as sleeping under
> > current activity in Enterprise Manager. This is quiet normal as Sql Server
> > pages in and out processes as it runs them. If you keep refreshing it you may
> > catch it as active.
> >
> > If you want to check that it is actually doing something, you can monitor it
> > with profiler or if you double click on the current activity, you get details
> > of the current SQL statement being performed. If you refresh that you should
> > see it change.
> >
> > Hope this helps
> >
> > John
> >
> > "CC&JM" wrote:
> >
> > > Hello,
> > >
> > > In my Enterprise Manager i see one job that i know its running(i look
> > > locally on server) and jobs status appear like job is not executing(job
> > > status is wrong)
> > > Is there any patch to apply to EM?
> > >
> > > Thanks and best regards.

Job Status Wrong

Hello,
In my Enterprise Manager i see one job that i know its running(i look
locally on server) and jobs status appear like job is not executing(job
status is wrong)
Is there any patch to apply to EM?
Thanks and best regards.Hi
I take it that by wrong status, you mean it is showing as sleeping under
current activity in Enterprise Manager. This is quiet normal as Sql Server
pages in and out processes as it runs them. If you keep refreshing it you ma
y
catch it as active.
If you want to check that it is actually doing something, you can monitor it
with profiler or if you double click on the current activity, you get detail
s
of the current SQL statement being performed. If you refresh that you should
see it change.
Hope this helps
John
"CC&JM" wrote:

> Hello,
> In my Enterprise Manager i see one job that i know its running(i look
> locally on server) and jobs status appear like job is not executing(job
> status is wrong)
> Is there any patch to apply to EM?
> Thanks and best regards.|||Hello John,
Thanks for your answer, now i see the status of the job quit well but
yesterday i had a job that runs 4 example at 10:00 12:00 14:00 and so on..
and at 18:00 when i look at EM "Last Run Status" showed 10:00 and "Next Run
Date" showed 12:00.
I know that the problem was with my EM because in the EM of my partner i saw
the job status normally.
Thanks John,
Best regards
"John Bandettini" wrote:
[vbcol=seagreen]
> Hi
> I take it that by wrong status, you mean it is showing as sleeping under
> current activity in Enterprise Manager. This is quiet normal as Sql Server
> pages in and out processes as it runs them. If you keep refreshing it you
may
> catch it as active.
> If you want to check that it is actually doing something, you can monitor
it
> with profiler or if you double click on the current activity, you get deta
ils
> of the current SQL statement being performed. If you refresh that you shou
ld
> see it change.
> Hope this helps
> John
> "CC&JM" wrote:
>|||Hi
I misunderstood your problem, I thought you were looking at current
activity. If you were looking at jobs and the job did not seem to be running
,
did you refresh the display? Once you have opened something in Enterprise
manager, like jobs it will not automatically refresh. You need to either
right click and choose refresh or press F5.
Regards
John
"CC&JM" wrote:
[vbcol=seagreen]
> Hello John,
> Thanks for your answer, now i see the status of the job quit well but
> yesterday i had a job that runs 4 example at 10:00 12:00 14:00 and so on..
> and at 18:00 when i look at EM "Last Run Status" showed 10:00 and "Next Ru
n
> Date" showed 12:00.
> I know that the problem was with my EM because in the EM of my partner i s
aw
> the job status normally.
> Thanks John,
> Best regards
> "John Bandettini" wrote:
>

Job Schedule

I would like to view all the scheduled jobs , sorted by Next Run Date. When
I use Enterprise Manager and sort by that column, they are not sorted
correctly.
Suggestions?Hopefully following query can give you the required result.
select sj.name, sj.description,
case sj.enabled
when 0 then 'Enabled'
else 'Disabled' end as 'Job Status',
sjs.next_run_date,
right('000000' + convert(varchar(6),sjs.next_run_time),6) 'Next Run Time'
from msdb.dbo.sysjobs sj, msdb.dbo.sysjobschedules sjs
where sj.job_id = sjs.job_id
order by sjs.next_run_date, sjs.next_run_time
Please let us know whether this helped you or not?
"John Carlton" wrote:
> I would like to view all the scheduled jobs , sorted by Next Run Date. When
> I use Enterprise Manager and sort by that column, they are not sorted
> correctly.
> Suggestions?|||Yes, perfect. Thanks!
"Absar Ahmad" wrote:
> Hopefully following query can give you the required result.
> select sj.name, sj.description,
> case sj.enabled
> when 0 then 'Enabled'
> else 'Disabled' end as 'Job Status',
> sjs.next_run_date,
> right('000000' + convert(varchar(6),sjs.next_run_time),6) 'Next Run Time'
> from msdb.dbo.sysjobs sj, msdb.dbo.sysjobschedules sjs
> where sj.job_id = sjs.job_id
> order by sjs.next_run_date, sjs.next_run_time
> Please let us know whether this helped you or not?
> "John Carlton" wrote:
> > I would like to view all the scheduled jobs , sorted by Next Run Date. When
> > I use Enterprise Manager and sort by that column, they are not sorted
> > correctly.
> > Suggestions?

Job Schedule

I would like to view all the scheduled jobs , sorted by Next Run Date. When
I use Enterprise Manager and sort by that column, they are not sorted
correctly.
Suggestions?Hopefully following query can give you the required result.
select sj.name, sj.description,
case sj.enabled
when 0 then 'Enabled'
else 'Disabled' end as 'Job Status',
sjs.next_run_date,
right('000000' + convert(varchar(6),sjs.next_run_time),6) 'Next Run Time'
from msdb.dbo.sysjobs sj, msdb.dbo.sysjobschedules sjs
where sj.job_id = sjs.job_id
order by sjs.next_run_date, sjs.next_run_time
Please let us know whether this helped you or not?
"John Carlton" wrote:

> I would like to view all the scheduled jobs , sorted by Next Run Date. Wh
en
> I use Enterprise Manager and sort by that column, they are not sorted
> correctly.
> Suggestions?|||Yes, perfect. Thanks!
"Absar Ahmad" wrote:
[vbcol=seagreen]
> Hopefully following query can give you the required result.
> select sj.name, sj.description,
> case sj.enabled
> when 0 then 'Enabled'
> else 'Disabled' end as 'Job Status',
> sjs.next_run_date,
> right('000000' + convert(varchar(6),sjs.next_run_time),6) 'Next Run Time'
> from msdb.dbo.sysjobs sj, msdb.dbo.sysjobschedules sjs
> where sj.job_id = sjs.job_id
> order by sjs.next_run_date, sjs.next_run_time
> Please let us know whether this helped you or not?
> "John Carlton" wrote:
>

Job Schedule

I would like to view all the scheduled jobs , sorted by Next Run Date. When
I use Enterprise Manager and sort by that column, they are not sorted
correctly.
Suggestions?
Hopefully following query can give you the required result.
select sj.name, sj.description,
case sj.enabled
when 0 then 'Enabled'
else 'Disabled' end as 'Job Status',
sjs.next_run_date,
right('000000' + convert(varchar(6),sjs.next_run_time),6) 'Next Run Time'
from msdb.dbo.sysjobs sj, msdb.dbo.sysjobschedules sjs
where sj.job_id = sjs.job_id
order by sjs.next_run_date, sjs.next_run_time
Please let us know whether this helped you or not?
"John Carlton" wrote:

> I would like to view all the scheduled jobs , sorted by Next Run Date. When
> I use Enterprise Manager and sort by that column, they are not sorted
> correctly.
> Suggestions?
|||Yes, perfect. Thanks!
"Absar Ahmad" wrote:
[vbcol=seagreen]
> Hopefully following query can give you the required result.
> select sj.name, sj.description,
> case sj.enabled
> when 0 then 'Enabled'
> else 'Disabled' end as 'Job Status',
> sjs.next_run_date,
> right('000000' + convert(varchar(6),sjs.next_run_time),6) 'Next Run Time'
> from msdb.dbo.sysjobs sj, msdb.dbo.sysjobschedules sjs
> where sj.job_id = sjs.job_id
> order by sjs.next_run_date, sjs.next_run_time
> Please let us know whether this helped you or not?
> "John Carlton" wrote:
sql

Job Names Created for Subscriptions

Hi All,
I'm new to Reporting Services and have just created my first data-driven
subscription for a report. In the SQL Enterprise Manager, the job name seems
to take the shape of a GUID. Is there a way around this so administration is
easier and these names are "human readable"?
Thanks in advance!
Kind regards - FredI'd also like to know the answer to this. The DBAs here likes to keep a
close eye on the jobs and they seem really annoyed by these GUIDs. I pointed
out that they could see it was a Reporting Services job and they could sort
on that column to put them all together but they didn't really consider that
a good solution.sql

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 hangs Enterprise Manager

Hi
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
>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|||Hi
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.|||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 Failed

Hi,
I've a problem with a job in SQL Server 2000.
By enterprise Manager I try to schedule a job which will run a stored
procedure.
When I finish to schedule it I try to run it up manually but after few
seconds it displays to me a failed message.
The error message don't have an id so I cannot search for it on the
web.
Someone could give me any kind of explanation about?
Maybe a user permission issue? I try to run the job as sa user.

thanks a lot in advance

Piero Cannizzaro"Piero Cannizzaro" <piero_cannizzaro@.libero.it> wrote in message
news:a3b5ba25.0404190257.5b813e72@.posting.google.c om...
> Hi,
> I've a problem with a job in SQL Server 2000.
> By enterprise Manager I try to schedule a job which will run a stored
> procedure.
> When I finish to schedule it I try to run it up manually but after few
> seconds it displays to me a failed message.
> The error message don't have an id so I cannot search for it on the
> web.
> Someone could give me any kind of explanation about?
> Maybe a user permission issue? I try to run the job as sa user.

Post the error message here.

> thanks a lot in advance
> Piero Cannizzaro

Job entries in eventlist

Hi all
in enterprise manager of aur SQL-Server 2000, we defined some backup-jobs.
All these jobs are logged in the eventlist, although the control field in th
e
job proprties are deactivated. The list contains tons of event entries every
day of all backups and so much the worse die log backups.
It's this a fault in the enterprise manager or SQL-server? And, have any one
a reason for this problem?
Thanks
FieteIf I understand you question correctly:
It isn't Agent that log each time a backup is performed. It is SLQ Server.
And you cannot turn it
off, I'm afraid. Considering posting such a request to sqlwish@.microsoft.com
.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Fiete" <Fiete@.discussions.microsoft.com> wrote in message
news:AC1F6A5E-64E4-48CB-AD8E-BA39535BFD37@.microsoft.com...
> Hi all
> in enterprise manager of aur SQL-Server 2000, we defined some backup-jobs.
> All these jobs are logged in the eventlist, although the control field in
the
> job proprties are deactivated. The list contains tons of event entries eve
ry
> day of all backups and so much the worse die log backups.
> It's this a fault in the enterprise manager or SQL-server? And, have any o
ne
> a reason for this problem?
> Thanks
> Fiete

Job entries in eventlist

Hi all
in enterprise manager of aur SQL-Server 2000, we defined some backup-jobs.
All these jobs are logged in the eventlist, although the control field in the
job proprties are deactivated. The list contains tons of event entries every
day of all backups and so much the worse die log backups.
It's this a fault in the enterprise manager or SQL-server? And, have any one
a reason for this problem?
Thanks
FieteIf I understand you question correctly:
It isn't Agent that log each time a backup is performed. It is SLQ Server. And you cannot turn it
off, I'm afraid. Considering posting such a request to sqlwish@.microsoft.com.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Fiete" <Fiete@.discussions.microsoft.com> wrote in message
news:AC1F6A5E-64E4-48CB-AD8E-BA39535BFD37@.microsoft.com...
> Hi all
> in enterprise manager of aur SQL-Server 2000, we defined some backup-jobs.
> All these jobs are logged in the eventlist, although the control field in the
> job proprties are deactivated. The list contains tons of event entries every
> day of all backups and so much the worse die log backups.
> It's this a fault in the enterprise manager or SQL-server? And, have any one
> a reason for this problem?
> Thanks
> Fiete

Job entries in eventlist

Hi all
in enterprise manager of aur SQL-Server 2000, we defined some backup-jobs.
All these jobs are logged in the eventlist, although the control field in the
job proprties are deactivated. The list contains tons of event entries every
day of all backups and so much the worse die log backups.
It's this a fault in the enterprise manager or SQL-server? And, have any one
a reason for this problem?
Thanks
Fiete
If I understand you question correctly:
It isn't Agent that log each time a backup is performed. It is SLQ Server. And you cannot turn it
off, I'm afraid. Considering posting such a request to sqlwish@.microsoft.com.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Fiete" <Fiete@.discussions.microsoft.com> wrote in message
news:AC1F6A5E-64E4-48CB-AD8E-BA39535BFD37@.microsoft.com...
> Hi all
> in enterprise manager of aur SQL-Server 2000, we defined some backup-jobs.
> All these jobs are logged in the eventlist, although the control field in the
> job proprties are deactivated. The list contains tons of event entries every
> day of all backups and so much the worse die log backups.
> It's this a fault in the enterprise manager or SQL-server? And, have any one
> a reason for this problem?
> Thanks
> Fiete