scotto72
Member
Here's a puzzler for all you guru's out there:
Is there any way to change the processing options on the job scheduler at run time? Here's the situation:
I've got a bunch of different financial reports that need to be run twice a month (Approximately 40). One of the processing options is the period, which needs to be changed every OTHER time the job is run. Is there an easy way to do that, a hard way to do that, or am I just engaging in fanciful thinking? (I don't mind messing with BLOBS and stuff in the R983051 or whatever, just need to get a solution.) And failing that, is there a way to do the same through runube.exe? We're an NT/SQL shop here (See sig) and I'm VERY curious as this would save one of our people a pretty significant chunk of time (These reports get distributed across our company to various people and I'm trying to automate that as well.) Any help greatly appreciated, even if it's "Upgrade to XE" or "Wait for B9" or "Not a chance." Thanks in advance!
B7332 sp10.1 SQL7.0 NT 4.0 sp6a
ESU's: All prerequisites, JD5550
Is there any way to change the processing options on the job scheduler at run time? Here's the situation:
I've got a bunch of different financial reports that need to be run twice a month (Approximately 40). One of the processing options is the period, which needs to be changed every OTHER time the job is run. Is there an easy way to do that, a hard way to do that, or am I just engaging in fanciful thinking? (I don't mind messing with BLOBS and stuff in the R983051 or whatever, just need to get a solution.) And failing that, is there a way to do the same through runube.exe? We're an NT/SQL shop here (See sig) and I'm VERY curious as this would save one of our people a pretty significant chunk of time (These reports get distributed across our company to various people and I'm trying to automate that as well.) Any help greatly appreciated, even if it's "Upgrade to XE" or "Wait for B9" or "Not a chance." Thanks in advance!
B7332 sp10.1 SQL7.0 NT 4.0 sp6a
ESU's: All prerequisites, JD5550