Ok, Shaun, i just checked and my SQL 2K5 has 80 compatibility like you said, but it works in 2k, so the suggested answer isn't correct across platforms.

so what...

I disagree! it works perfectly in both 2K and 2K5. i have both versions and i tried it out just to be double sure.

Unfortunately, that is a challenge,...

SQL ORACLE (3/18/2008)

---

It may be right or wrong.

Right:

If your virtual server does not have enough resource, your jobs may not be processed in time. As a result, you may...

I agree with Brandie and Bob (as with so many others who have posted replies on this thread).

I'm very new to SQL Server, i have a Oracle Applications Developer/10g DBA...

thanks all,

after i executed the block of code (Phillip's) and refreshed my connection, i could open the properties of SQLSERVERAGENT, which prior to now had been greyed out(disabled).

As i went...

sorry, forgot to include the message on the result pane

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Configuration option 'Agent XPs' changed from...

Hi Phillip,

this was displayed on the result pane after i ran the block of code against the master database.

Remote connections are enabled and i have tried to start SQLSERVERAGENT to...

thanks's Phillip,

what database should i run this against? msdb?

sp_configure 'show advanced options','1'

RECONFIGURE

go

sp_configure 'Agent XPs','1'

RECONFIGURE

go

This will enable Agent XP's and SQL Server Agent should start.

here is the content of SQLAgent.out

2008-03-07 10:23:33 - ! [298] SQLServer Error: 2, Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQLSTATE 08001]

2008-03-07 10:23:33 -...

these lines are from the records that read Error Log in the EventClass Column

2007-07-19 13:03:24.54 spid51 Configuration option 'show advanced options' changed from 0 to...

thanks, i didn't know that. i'll correct it at once.

Cheers

thanks for responding.

the backupfile is not appended to, it creates a new file each day, that is then zipped and moved to another physical location. so E:\Backups_Loc is empty...