ok, and this is the only code you have behind that perticular functionality or some other set of code as well?

Not able to find any specific problem with this set...

if its not sql compressed backup or litespeed compressed backup, then for estimate, it should be nearly equaly to mdf file size of database.

ok, next try then

is this perticualr code working ok?

because when I replaced your variable with current date, then I am getting as below result :-

getdate()...

ohhok, so you have the database but it was never backed up because of thinking on the estimate size it will take? 😀 😀 😀

i mean something like :-

@assayid int,

@dateassayrequested datetime

AS

if @assayid <>0 set @assayid = 0

and then your select statement

have you configured the correct operator in notification tab of sql job?

i think it could be because of :-

(@assayID = 0 OR assayid = @assayid).

can you set the @assayid = 0 on top and then @assayid = whatever passed.

In this way...

like the level suggest(L1), it will be for some jr DBA role where the person have the basic idea on sql server as well must be aware of new versions...

if you run below query on the serevr where u have the distributor database, you will come to know the errors its generating.

use distribution

go

select * from MSrepl_errors order by time...

try this :-

SELECT s.database_name,

m.physical_device_name,

cast(s.backup_size/1000000 as varchar(14))+' '+'MB' as bkSize,

CAST (DATEDIFF(second,s.backup_start_date , s.backup_finish_date)AS VARCHAR(4))+' '+'Seconds' TimeTaken,

s.backup_start_date,

CASE s.[type]

WHEN 'D' THEN 'Full'

WHEN 'I' THEN 'Differential'

WHEN 'L' THEN 'Transaction...

seems like the problem with replication? What kind of replication you have configured?

Also are you able to get any more detail in ms_replcommands in distributor database?

maintenace task is windws task or sql task?

if windows check application log.

if sql then check if any DTS is configured for that. And check DTS history.

Which version of sql...

expand job and check individual step within job

when you saying 1000 server, you mean sql server or windows server.

both are different tasks and need different profile people. its upto which profile you interested in

even I use the spotlight and its quiet handy for digging into the problem. But sometime it takes ages to respond. Hope new version 7.0 have improved in responding.

Also Performance...