PS Query & SQL

Okay, both are query related, but also job related, and neither scenario makes any sense to me.

1. I have a scheduled query that gets sent to the users.  I updated the prompts on the scheduled query run control.   The users were not getting any data.  I had to go into the scheduled job and inactivate it and then update the effective date and reactivate it.  Then it picked up my new prompts.  Why?  This makes no sense.  The only thing effective dated was the scheduled job.  The Scheduled Query Run control does not have an effective date. The table with the query prompts does not have an effective date.  What am I missing?
2. Same thing basically.  I have a process that picks up data with a pop select query and then creates a file to send.  But it wasn't picking them up.  I had to update the scheduled job effective date.   This isn't making any sense.  The run control and query prompts are not effective dated.

Does this make any sense?  

Okay, both are query related, but also job related, and neither scenario makes any sense to me.

1. I have a scheduled query that gets sent to the users.  I updated the prompts on the scheduled query run control.   The users were not getting any data.  I had to go into the scheduled job and inactivate it and then update the effective date and reactivate it.  Then it picked up my new prompts.  Why?  This makes no sense.  The only thing effective dated was the scheduled job.  The Scheduled Query Run control does not have an effective date. The table with the query prompts does not have an effective date.  What am I missing?
2. Same thing basically.  I have a process that picks up data with a pop select query and then creates a file to send.  But it wasn't picking them up.  I had to update the scheduled job effective date.   This isn't making any sense.  The run control and query prompts are not effective dated.

Does this make any sense?  

Okay, both are query related, but also job related, and neither scenario makes any sense to me.

1. I have a scheduled query that gets sent to the users.  I updated the prompts on the scheduled query run control.   The users were not getting any data.  I had to go into the scheduled job and inactivate it and then update the effective date and reactivate it.  Then it picked up my new prompts.  Why?  This makes no sense.  The only thing effective dated was the scheduled job.  The Scheduled Query Run control does not have an effective date. The table with the query prompts does not have an effective date.  What am I missing?
2. Same thing basically.  I have a process that picks up data with a pop select query and then creates a file to send.  But it wasn't picking them up.  I had to update the scheduled job effective date.   This isn't making any sense.  The run control and query prompts are not effective dated.

Does this make any sense?  

I've been seeing the same behavior recently, Dana, and I have a hard time believing you and I have suddenly forgotten how to use these tools. Something must have changed underneath.

Okay, both are query related, but also job related, and neither scenario makes any sense to me.

1. I have a scheduled query that gets sent to the users.  I updated the prompts on the scheduled query run control.   The users were not getting any data.  I had to go into the scheduled job and inactivate it and then update the effective date and reactivate it.  Then it picked up my new prompts.  Why?  This makes no sense.  The only thing effective dated was the scheduled job.  The Scheduled Query Run control does not have an effective date. The table with the query prompts does not have an effective date.  What am I missing?
2. Same thing basically.  I have a process that picks up data with a pop select query and then creates a file to send.  But it wasn't picking them up.  I had to update the scheduled job effective date.   This isn't making any sense.  The run control and query prompts are not effective dated.

Does this make any sense?