Yes once a day.

The job is not failing,but it takes long than normal.instaed of taking less 20min it took 2 hours

I will do so,to my suprise the backup ran normal today.we take log backup everyday which takes less 15 min but yesterday it took more than 2 hours.

Thanks,

The query is working perfect but the problem now is that query must run in SSRS Dataset and when i try to upload the file to report Manager it returns...

Thanks , i will make the jobs not to run at the same time.I am not good to tsql.

Thanks

So how can i come around the solution.Must i schedule jobs at different times?

This is what the proc does.

CREATE procedure [dbo].[sp_HostDriveStatusProcess]

(

@SiteName nvarchar(100),

@HostIP nvarchar(15),

@SystemDrive nvarchar(1),

@datadrive nvarchar(1),

@BackupDrive nvarchar(1),

@BackupDrive2 nvarchar(1)

)

as

begin

set nocount on

select

a.systemname as HostName,

left(a.deviceid,1) as DriveName,

cast(cast(a.drivesize as numeric(20,2))/1024/1024/1024 as numeric(13,2)) as TotalSpace,

cast(cast(a.freespace as...

Thank you for your help

I am not seeing the corrections bru

thanks

i dont know what is happening,the code you send me is having an uncommon symbol after Today()),but when i am replying it shows < symbol.

I do not understand the <2,

Thank you so much but please i do not understand the < in the expression.Sorry i am new to Sql.

=IIf(DateDiff("d",Fields!LastDiffBackupDate.Value, Today())<2,"Green", IIf(IS Nothing(Fields!LastDiffBackupDate.Value),"Transparent","Red"))

Below are the conditions to be met...

Thank you i will try that.So it must be like

=IIf(DateDiff("d",Fields!LastDiffBackupDate.Value, Today())<=2,"Green", IIf(IS Nothing(Fields!LastDiffBackupDate.Value),"Transparent","Red")).

Below are the conditions which must be satisfied by the expression

1.if the column lastdiffbackupdate value is...

Thanks Taylor i will try that.

Thank you it worked perfect