 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
Jason Hoskins
Joined: 12 Mar 2004
Posts: 68
|
|
 Identify all modified jobs |
 |
How would I go about querying the job database to write the Modification Status to a file for a particular frequency? For example, all jobs modified in last 7 days.
Thanks.
|
|
| Tue Apr 01, 2008 1:16 pm |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7949
|
|
| |
|
Windows Edition or Multi-platform Edition of 24x7?
|
|
| Tue Apr 01, 2008 1:18 pm |
|
|
Jason Hoskins
Joined: 12 Mar 2004
Posts: 68
|
|
| |
|
Windows 3.4
|
|
| Tue Apr 01, 2008 1:19 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7949
|
|
| |
|
Please see the 2nd example in the JobList topic in the on-line help (click the Examples button in that topic to see code examples).
In that example, replace LAST_RUN with MODIFY_TIME. If you want you can also add MODIFY_USER. To get date difference between that date and now, you can use Today to get the current system date and use DateDiff for the difference.
Hope this helps
|
|
| Tue Apr 01, 2008 1:37 pm |
|
|
Jason Hoskins
Joined: 12 Mar 2004
Posts: 68
|
|
| |
|
I forgot to mention...I want all modified jobs. So how do I retrieve the list of jobs so I can cycle through them?
|
|
| Tue Apr 01, 2008 1:57 pm |
|
|
Jason Hoskins
Joined: 12 Mar 2004
Posts: 68
|
|
| |
|
I found the joblist function which gives me what I need. Thanks for the quick responses!
|
|
| Tue Apr 01, 2008 2:07 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7949
|
|
| |
|
Scroll down to the second example, it has a loop and does exactly what you want.
|
|
| Tue Apr 01, 2008 2:29 pm |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
