noeld:

Good one.

Thank you for "undocumented" way to get  jobs info

just tested xp_sqlagent_enum_jobs  on sql server 2005:

working fine.

How many DBA do you know who do not use "undocumented" sp,  DBCC, etc?

Sorry, the page you requested was not found.

what date in sysjobhistory? There can be record but if there is not in Sysjobschedules - looks like somebody 'edited' the job

what date in sysjobhistory? There can be record but if there is not in Sysjobschedules - looks like somebody 'edited' the job

Did you try SQLDMO - JobServer object's Status property?

It could help you

Try: sp_spaceused Table_name

Antares686

you got result in MB - sp_helpfile in KB

Thank you Solar.

----------------------

I checked EventViewer: Agent stoped before error #17148 was written in log.

Same time if I am using 010 severity in alert - it fires before Agent stopes

But problem...

Did you try 'sp_helpfile'? It can be the answer for you.

Create a global variable in your dts package.

then a stored procedure, something like:

----------

declare @month varchar(50)

set @month=DATENAME(m,getdate())

exec master..xp_cmdshell 'dtsrun /S srvname /E /N yourPackage /A yourvarname:8="C:/" & @month & "/data.txt"'

---

Edited by...