Hi Jack

first i select databases which i need to be take backup

2) click on next,next,next, come in Specify Backup Disk Directory.

in this i set the path where i have to...

Hi

Can anyone please tell me how to run the following command :

xp_cmdshell INSERT INTO test.dbo.SERVERAGENTSTATUS(ASTATUS) exec MASTER..XP_SERVICECONTROL 'QUERYSTATE','SQLSERVERAGENT'

Please help in making this dynamic command.

Thanks for replying Jonthan.

What my point was if the SMTP server settings gets changed, then would cosysmail will work fine ?? or need any changes

Hi Gail

Thanks a lot for all your help and support . It was a permission error as u rightly said. You helped me immensely. Thanks

Hello

Below is the error log details . I have tried restarting the server number of times but all in vain.

2008-12-07 13:29:06.62 server Microsoft SQL Server ...

there is no change to sql server service accounts. and the above logs generated after server restart.

Yes , i have checked the drive is readable and all files are present there.

I have just checked the error logs and found this .

2008-12-08 20:12:45.18 spid58 Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to...

Thanks for the reply !!

I have one doubt , if i create the scripts for the job and execute it on the destination , will be job will get created...

I clicked the first option (Sql server). Didnt selected the second option (Other data source)

my servername is : chovavdb01fage

so i am creating Linked server with this name

Hi

Can you please tell me what needs to edited if i want to fetch this info from multiple servers

Hi Tushar

Thanks for replying !!!!

I have executed this now :

DECLARE @server VARCHAR(50) ...

Can anyone help out on this

Hi Steve

Thanks for replying !!!!

Actaully sp_exectutesql always return (0) for success and (1) for failure.

In my case it is just returning (0) even if the agent on some...