.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to be informed of missed schedules ?

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server


I'm running SQL Server 2008 SP1 with CU9. Sometimes, it happens that a job is not run according to the schedule because its status is still "executing". Of course I don't get any information: the job is not completed, nor failed. Is there a way to be informed of missed schedules ?


View Complete Post

More Related Resource Links

Data missed on processing Partition

HI, I have created partition in two partition in SSAS cube, one contain data of >=getdate()-10 to <getdate()-2 while other conains >=getdate()-2 to <getdate(),,,,[[getdate() converted to date part only ]] i have created one SSIS package in which i have used "Analysis Service Processing task" and processed that partition whcih contaons >=gedate()-2 to <getdate() in Full Process mode. but i have got error which i explained you below. supoose on 20 Aug,i have data from 11 Aug to 18 aug and when i process the SSIS package ,it runs fine and update 19 August data but also eliminate the data of 17 August.   Kindly let me know if there is some mistake comiited by me or suggest.   Regards Shraddha  

is there a way to disable ALL report schedules at once?

is there any way for me to disable ALL scheduled report runs at once? I'm in the process of migrating from 2000 to 2008 and I'd like to enable reports one at a time, at least initially, just to be sure everything is working. Then once we're sure it's all working I'd like to re-enable the schedules.

For a full text index, what is the difference in these types of population schedules?


I am using SQL2008 and created a full-text index on 1 of my tables. Going through the wizard, I was offered (2) types of population schedules as follows:

New Table Schedule: Define a population schedule for a table.

New Catalog Schedule: Define a population schedule for a full-text catalog.

I am familiar with a 'Catalog' schedule for population which I do nightly and was similar to configuration on SQL2000 for a full text index.  However, what is the difference for a 'Table' schedule vs the 'Catalog' population schedule? I have the definitions above, but if someone with knowledge could offer a better in depth explanation in comparison, and if I should use both or not (I have just a Catalog population scheduled currently), this would be helpful.


Maintenance Plan with Multiple Sub Plans with Multiple Schedules


I have a Maintenance Plan that have various other subplans. Each subplan has its own schedule. For instance, one will be an hourly log backup, a daily complete backup and a weekly maintenance subplan. Now when ever the log backup takes place, say subplan1 succeeds HOWEVER, the other Subplans subplan 2 and subplan 3 show errors on the error logs. I know that these messages dont matter, however the GLARING X's marks on the Maintenance Plan History does not do service. This way i will have to go in and check each history. Definitely not as simple as looking at Tick marks on the work well done.

IS there a solution. (other than creating a separate maintenance plan for each subplan)!!!

PLease HELP. Thanks. 

Custom Content Type is missed while restoring Document Libary template



I have a document library and i use a custom template "templateA" in it,This also inherits from "Folder" content type. When i'm restoring this template backup file to a new library,It missed the content type "templateA" and appears as "Folder" in all items.

I use a publishing site, and i created the content type in site level, I also created the document library in sub site level where i used the template,

Is there any work arround to get the custom content type in restored Libray.I use moss 2007.


Recreated SSP "Content sources and crawl schedules" Error?


This is a follow up question to

Okay, I created a new SSP with a different name. Ran fine. However, when I clicked "Content sources and crawl schedules", I got this error:

Could not find stored procedure 'dbo.proc_MSS_GetCrawlHistory'.   at Microsoft.SharePoint.Portal.Search.Admin.Pages.SearchAdminPageBase.ErrorHandler(Object sender, EventArgs e)
   at Microsoft.SharePoint.Portal.Search.Admin.Pages.SearchSSPAdminPageBase.OnError(EventArgs e)
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend