Jump to content

PQ Problem - Only Receiving 2 of 5 scheduled


MikieP

Recommended Posts

On Sunday, January 3rd, I had five queries scheduled to run. Two ran at 4:26 AM PST, I did the "copy" thing to get two more to run mid-afternoon, and the last ran around 5PM. This morning I am facing the same problem; five queries scheduled, two ran at 3:27AM PST, and no sign as yet of the other three.

 

I suppose I could do the "copy" thing again as that seems to be a bandaid solution, but I am compelled to ask why. The system has been running so well recently, the queries I've scheduled were all run at the same time last week, and the problem must not be system wide or these forums would be full of complaints.

 

Any suggestions or solutions ? Anyone else having the same problem?

Link to comment
I just realized...I have not received any PQ since the new year...checked profile and it (my weekly PQ) is stuck at:

 

Last Run 01/01/2010 12:00:00...

 

I resubmitted it...I guess I will see...

I'd make a copy of it and submit that. The 12:00:00 run time is the flag GS puts on PQs that fail. I think it may be the case (and I think you have confirmed it since it didn't try to run 1/8) that this will never run because of that error flag.

 

(Not that there is anything really wrong with the PQ.)

Link to comment
Guest
This topic is now closed to further replies.
×
×
  • Create New...