January 19, 2010 at 5:48 am
i want to find thebackup job details i.e at what time the backup is scheduled and type of backup job and whether it is type or disk ?
January 19, 2010 at 5:59 am
Is it a scheduled Job, or part of your maintenance plan?
Scheduled Job?
Have a look at the steps, you'll see all the properties if its T-SQL Based commands, and you'll have to open SSIS if its apackage running, and view the steps.
Maintenance Plan....sort of the same as above step with SSIS - but you'll be able to see the steps without opening the physical BI studio....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 19, 2010 at 6:15 am
ramyours2003 (1/19/2010)
i want to find thebackup job details i.e at what time the backup is scheduled and type of backup job and whether it is type or disk ?
Check what Henrico told.
Also see the system tables in msdb databasebackupset,BACKUPMEDIAFAMILY & write a select statement.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply