|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Job Scheduler Question - 2005I have a scheduled job for a DTS package and was reviewing the history, but
it only keeps 50 events listed in the history. Is there any way to expand this or a query that can be used to extract more history about the executed jobs? Are you talking of how many executions it has history for? If so, Right-click Agent, Properties,
History. -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Big Ern" <Big***@discussions.microsoft.com> wrote in message news:9528FF37-5BD1-4CA5-AFC5-B7EC2F3D0AE0@microsoft.com... >I have a scheduled job for a DTS package and was reviewing the history, but > it only keeps 50 events listed in the history. Is there any way to expand > this or a query that can be used to extract more history about the executed > jobs? Yes I am talking about the history and know how to access it. I was asking if
there was a way to expand the number of executions or having a way to look past the list of 50. Show quote "Tibor Karaszi" wrote: > Are you talking of how many executions it has history for? If so, Right-click Agent, Properties, > History. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > > > "Big Ern" <Big***@discussions.microsoft.com> wrote in message > news:9528FF37-5BD1-4CA5-AFC5-B7EC2F3D0AE0@microsoft.com... > >I have a scheduled job for a DTS package and was reviewing the history, but > > it only keeps 50 events listed in the history. Is there any way to expand > > this or a query that can be used to extract more history about the executed > > jobs? > > > Did you look in the dialog I suggested and change the values you have there? Are you saying that
Agent doesn't respect the values you have set in this dialog? -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Big Ern" <Big***@discussions.microsoft.com> wrote in message news:5EAB9989-79CB-48EC-A34F-8848F356EA7A@microsoft.com... > Yes I am talking about the history and know how to access it. I was asking if > there was a way to expand the number of executions or having a way to look > past the list of 50. > > "Tibor Karaszi" wrote: > >> Are you talking of how many executions it has history for? If so, Right-click Agent, Properties, >> History. >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> >> >> "Big Ern" <Big***@discussions.microsoft.com> wrote in message >> news:9528FF37-5BD1-4CA5-AFC5-B7EC2F3D0AE0@microsoft.com... >> >I have a scheduled job for a DTS package and was reviewing the history, but >> > it only keeps 50 events listed in the history. Is there any way to expand >> > this or a query that can be used to extract more history about the executed >> > jobs? >> >> >>  |
|||||||||||||||||||||||
Other interesting topics