EXECUTE msdb.dbo.sp_add_alert @name = N'TransactionLOG Databasename 70 %',

 @message_id = 0, @severity = 0, @enabled = 1,

@delay_between_responses = 60,

@performance_condition = N'SQLServeratabases|Percent Log Used|Databasename|>|80',...

Hi, I am newbie to reporting! After creating SP, what's next?

Ensure the SQL Server Agent Started. Job Schedules option is enabled and job is enable as well.

Good Luck!

Thanks a lot!

I encounter similar problem. In a domain have WIN2K server as PCB server and BDC server. after shutting down the BDC server. the job was working fine.

I encounter the some problem before. what I did was redured the memory size used from SQL server. Example if i have 4GB memory on the server. lets set 4GB...

1. used dbcc sqlperf (logspace) to check the log space utilization.

2. Log file is for recovery purposes. If you perform a full backup you can truncate the log file.

Yup! I am using the correct account. the account is administrator equalvalent and other server server using the same account works fine.

I run many jobs simultaneously in SQL server. Replication, Backup, parser  and etc. SQL server should be able to handle multi-tasking jobs. Of course, Higher hardware configuration for better speed.

Guys,

Thanks for your feedback! I able to send mail from outlook and confirmed the no problem with the account. From SQL Server agent properties on mail session. I can't select...

My reason changing that was enabled developer to view the SP content but they can't modify it!

Got it!!

Simple way is used the database maintenance plan to configure the full backup and transaction log backup. Remember to change the recovery...

Hi Guru,

May I know how to change it back from system SP to user defined SP? anyway to remove the system...

Thanks for your reply!