Job Searching Facility

[satheesh_color]

Hai All,


How to search a particular job in the repository. Because i have more than 180 jobs.If i want to pick a job we have to go through all the repository folders.Is there any option available to search a job in DS Designer or DS Manager?

Regards,
Satheesh.rajan

[sb_akarmarkar]

Use SELECT * FROM DS_JOBS WHERE NAME LIKE Jobname ... in Datastage Adminstrator command.. this is the only option


Thanks,
Anupam

[ArndW]

At the moment you need to do a query such as what Anupam has given in the Admin tool or by using TCL or by writing your own routine/job; fortunately with HAWK they have built this search into the client!

[roy]

Hi,
Beyond waht was already said, in the Director there is a search utility.
This utility will only let you find a job in a specific category, so if you used naming convention that uses some connection between job name and the category it's in you should be able to find it in no time even if all 180 jobs are in the same category.

IHTH,

[nick.bond]

create a routine with the following code with one input arg called "aSearchString"

Then you can open the routine in designer or manager and use the "TEST" functionality to find what you are looking for.

Code: Select all

      COL_HEADING = @FM
      COL_HEADING := "JOB ID           JOB CATEGORY                    JOB NAME" : @FM
      COL_HEADING := "-------------------------------------------------------------------"

      If UnAssigned(aSearchString) Or IsNull(aSearchString) Or Len(aSearchString) = 0
      Then
         Ans = @NULL
      End
      Else

         ClearSelect 8
         ClearSelect 9

         Ans = ""

         *Get list of jobids that contains aSearchString
         Command = "SEARCH DS_JOBOBJECTS TO 9" : @FM : "DATA " : aSearchString : @FM : "DATA"
         Command := @FM : "IF @SYSTEM.RETURN.CODE = 0 THEN GO SEARCH_FINISH"
         Command := @FM : "SELECT DS_JOBOBJECTS FROM 9 SAVING UNIQUE OBJIDNO TO 8"
         Command := @FM : "SEARCH_FINISH:"

         CALL DSExecute("TCL", Command, vOutput, vReturnCode)

         If vReturnCode < 0 Then
            Ans = "TCL Execute Failed" : @FM : "Command : " : Command : @FM : "Return Code ": vReturnCode
            Ans := @FM: "output : " : vOutput
            Return(Ans)
         End

         Loop
         While ReadNext ObjIdNo From 8

            Command = "SELECT JOBNO FMT'15L', CATEGORY FMT'30L',NAME FMT'30L' FROM DS_JOBS WHERE JOBNO = '"
            Command := ObjIdNo :"' COL.SUP COUNT.SUP;"
            CALL DSExecute("TCL", Command, vOutput, vReturnCode)

            If vReturnCode < 0 Then
               Ans = "TCL Execute Failed" : @FM : "Command : " : Command : @FM : "Return Code ": vReturnCode
               Ans := @FM: "output : " : vOutput
               Return(Ans)
            End


            Ans := vOutput

         Repeat

      End

      IF len(Ans) = 0 then Ans = 'Search For "': aSearchString : '" Not Found.'
      ELSE
         Ans = 'Search For "' : aSearchString : '" Results :' :@FM: COL_HEADING : Ans
      END

[ray.wurlod]

In Director you can choose (in the View menu) to disable the display of Categories, which will give you a single list of all the jobs in the project. It should be able to refresh 180 jobs in an acceptable time.

[kumar_s]

Here we find a person who might use 'dssearch' if it was available in his version.

[TNZL_BI]

Hi all,,, we have used the above routine however we would like to make this case insensitive. Is it possible to change this code slightly ???