Can you pls tell me any commans work with hours? I need to keep current 1 hr file and need to delete all other fils. Thanks.

We can do with Batch file with Delen command. I didn't try but someone sugges me. You can download Delen program from this link.

http://delenxrd.adoxa.cjb.net

Let me know .

No, I need to keep current hour files and delete all other files. It means if i run the package at 1.00PM then the package shouldn't delete the files which...

I shared this idea with my team but b/c of the Server space , we can't do like this. So can you share your code to delete files from...

Thanks for sharing your code. I wrote little differently to get result for my reqirement.

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

CREATE PROCEDURE [dbo].[spGetJobDetails] (@Job_Name as Varchar(50))

AS

SET NOCOUNT ON

SELECT TOP 2 sj.name,CASE WHEN run_status=1 THEN 'SUCCESS'...

It is working but it is giving error message for successed job also.

No, it doesn't give error description, if job failed. I tried sp_help_history procedure. But it is giving Job details but not error description. I need to see error description also...

Thanks for your idea. It save my time. Another method is just run the batch file in Job with cmdexc method.

Thanks a lot. It helps lot for me.