msdb.dbo.sysjobschedules less columns

msdb.dbo.sysjobschedules shows columns
scheduke_id,job_id,next_rundate,next_run
_time in MS Sqlserver 2005 beta3.
but the document (help) tells "name","enabled","freq_type","freq_interval"
too.
These columns were present in MS sqlserver 2000.
1. Is it that, some configuration is missing in my sql server 2005 beta3 DB?
2. or Do I need to do join with some other view/table to get these details.
Best regards,
Amit Kumar.Dear Amit,
I've got the CTP June for Sql Server 2005 and it happens the same.
""This topic is pre-release documentation and is subject to change in future
releases. Blank topics are included as placeholders.]""
Best regards,
"Amit Kumar" wrote:

> msdb.dbo.sysjobschedules shows columns
> scheduke_id,job_id,next_rundate,next_run
_time in MS Sqlserver 2005 beta3.
> but the document (help) tells "name","enabled","freq_type","freq_interval"
> too.
> These columns were present in MS sqlserver 2000.
> 1. Is it that, some configuration is missing in my sql server 2005 beta3 D
B?
> 2. or Do I need to do join with some other view/table to get these details
.
> Best regards,
> Amit Kumar.
>

msdb.dbo.sp_sqlagent_get_perf_counters using tons of cpu

msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu usage
on our server. We have hardly anything running in sqlagent. Can you give me
some ideas on how to fix this?
Thanks so much,
Jenna
Open Enterprise Manager and expand the Management>SQL Server Agent folder
and click on Alerts.You should see 9 alerts whose names all start with Demo.
Select them all and Delete. If you don't use alerts there is no point in
sp_sqlagent_get_perf_counters running. If there are no Alerts defined it
won't run.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jenna S." <JennaS@.discussions.microsoft.com> wrote in message
news:8C0811F4-49A9-428C-BFDE-DA060470CAAD@.microsoft.com...
> msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu
> usage
> on our server. We have hardly anything running in sqlagent. Can you give
> me
> some ideas on how to fix this?
> Thanks so much,
> Jenna

msdb.dbo.sp_sqlagent_get_perf_counters using tons of cpu

msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu usage
on our server. We have hardly anything running in sqlagent. Can you give me
some ideas on how to fix this?
Thanks so much,
JennaOpen Enterprise Manager and expand the Management>SQL Server Agent folder
and click on Alerts.You should see 9 alerts whose names all start with Demo.
Select them all and Delete. If you don't use alerts there is no point in
sp_sqlagent_get_perf_counters running. If there are no Alerts defined it
won't run.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jenna S." <JennaS@.discussions.microsoft.com> wrote in message
news:8C0811F4-49A9-428C-BFDE-DA060470CAAD@.microsoft.com...
> msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu
> usage
> on our server. We have hardly anything running in sqlagent. Can you give
> me
> some ideas on how to fix this?
> Thanks so much,
> Jenna

msdb.dbo.sp_sqlagent_get_perf_counters using tons of cpu

msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu usage
on our server. We have hardly anything running in sqlagent. Can you give m
e
some ideas on how to fix this?
Thanks so much,
JennaOpen Enterprise Manager and expand the Management>SQL Server Agent folder
and click on Alerts.You should see 9 alerts whose names all start with Demo.
Select them all and Delete. If you don't use alerts there is no point in
sp_sqlagent_get_perf_counters running. If there are no Alerts defined it
won't run.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jenna S." <JennaS@.discussions.microsoft.com> wrote in message
news:8C0811F4-49A9-428C-BFDE-DA060470CAAD@.microsoft.com...
> msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu
> usage
> on our server. We have hardly anything running in sqlagent. Can you give
> me
> some ideas on how to fix this?
> Thanks so much,
> Jenna

msdb.dbo.sp_send_dbmail error

I make PROCEDURE to send email useing db msdb and this PROCEDURE dbo.sp_send_dbmail like this

EXEC msdb.dbo.sp_send_dbmail

@.profile_name = 'saly',

@.recipients = @.email,

@.subject = @.subject,

@.body = @.body;

Go

And when EXEC it gives me mail qeue

and mail don't arrive where it goes i don't know please tell me what error

thankx very much

Check the mail log.

Have you start the smtp service

|||

hi

have the same promlem

and I have tried so many solutions.If u foud how to do so please tell me .

thanks

|||Its very likely an error with your SMTP server setup. Check to make sure that the machine you are sending the message from (sql server) is allowed to send smtp messages on your smtp server.
Tim

msdb.dbo.sp_send_dbmail error

I make PROCEDURE to send email useing db msdb and this PROCEDURE dbo.sp_send_dbmail like this

EXEC msdb.dbo.sp_send_dbmail

@.profile_name = 'saly',

@.recipients = @.email,

@.subject = @.subject,

@.body = @.body;

Go

And when EXEC it gives me mail qeue

and mail don't arrive where it goes i don't know please tell me what error

thankx very much

Check the mail log.

Have you start the smtp service

|||

hi

have the same promlem

and I have tried so many solutions.If u foud how to do so please tell me .

thanks

|||Its very likely an error with your SMTP server setup. Check to make sure that the machine you are sending the message from (sql server) is allowed to send smtp messages on your smtp server.
Tim

msdb.dbo.sp_send_dbmail error

I make PROCEDURE to send email useing db msdb and this PROCEDURE dbo.sp_send_dbmail like this

EXEC msdb.dbo.sp_send_dbmail

@.profile_name = 'saly',

@.recipients = @.email,

@.subject = @.subject,

@.body = @.body;

Go

And when EXEC it gives me mail qeue

and mail don't arrive where it goes i don't know please tell me what error

thankx very much

Check the mail log.

Have you start the smtp service

|||

hi

have the same promlem

and I have tried so many solutions.If u foud how to do so please tell me .

thanks

|||Its very likely an error with your SMTP server setup. Check to make sure that the machine you are sending the message from (sql server) is allowed to send smtp messages on your smtp server.
Tim

msdb.dbo.sp_help_job current_execution_step always returns 0 (unknown)

In SQL Server 2005, unless you belong to the sysadmin server role, executing
msdb.dbo.sp_help_job will always return "0 (unknown)" in the
current_execution_step column of first dataset returned.
Granting the user membership to the SQLAgentOperatorRole,
SQLAgentReaderRole, and SQLAgentUserRole does not make a difference.
Is this fixed in Service Pack 1?
Hello,
Based on my test, this issue is by design and still in SQL Server 2005 SP1.
According to the Books online, only the sysadmin could view the current
step informaton of a job.
sp_help_job (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms186722.aspx
SQL Server Agent Fixed Database Roles
http://msdn2.microsoft.com/en-us/library/ms188283.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti.../default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||I appreciate the response. I've read through those BOL entries before, so
maybe I'm missing something, or I haven't had enough coffee yet, but I can't
seem to find a note indicating that only users with the sysadmin role could
view the current job step.
In the event that this is indeed by design, are there any workarounds that I
can use to retrieve the step information without the user being added to the
sysadmin role?
|||Hello,
I did a deep research on how msdb.dbo.sp_help_job works.
Finnally, I found that msdb.dbo.sp_help_job invoke the system extended
stored procedure master.dbo.xp_sqlagent_enum_jobs and pass the parameter
@.is_sysadmin.
So my conclusion is unless you add the user to the sysadmin role, you could
not retrieve the step information for the job.
You may try to dig into the system stored procedure sp_help_job to find
whether there are any helpful information for you.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.