Hi.
I need to create a job that runs each monday and I need to setup a command procedure that searches the tape datadase for tapes that were allocated on the previous friday.

could someone help me out.

thanks
Rob

When you say "tape database" what are you referring too? SLS? Please advise.

If u know the actual device names (MKXNNN), then a small .com file can be made, which repeats for each the the tape device names.
for the .com file:
u have to start with assigning the sys$output to a file.
see the o/p in the file and check that the required information (allocated on "date","time ") is available at a required line and offset in the line.
use the $getdate to get the correct date which u want.
using the F$parse or F$search, compare with date available in the above stated field in the o/p file.

if the match is right then signal a flag, else continue to next drive.

any ways why u need to know what somebody did on "friday", any problem!!??

The tape database is SLS.

what happens is we allocate the tapes on friday but they get picked up the following monday and are sent to melb. and I want to schedule a job on monday to search for those tapes so I we have a list of the tapes going offsite.