Job for masking 6 databases

  • Hi friends,

    I have a script for masking.

    Using this script i want to create a job for masking 6 databases one by one. also i want to save the output after completing the masking on each database.

    Can any help on this step by step approach.

    Please do the needful.

    Its very urgent.

    Regasrds,

    sam

    Regards,
    SAM
    ***Share your knowledge.It’s a way to achieve immortality----Dalai Lama***

  • Can you post you script here so we can get a better understanding of exactly what you are after?

    Thanks

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • All I can do is guess based on what you've provided.

    How about using SQL Agent. When you set up the Job in SQL Agent you'll have to create Steps. The easy way to do this would be to just create a Step for each database, no modification needed to your script. You can then click on the Advanced tab of the Step and choose an output location for the output file. That should cover what you've said.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • What do you mean by 'masking'?

    Regards

    Lempster

  • Thanks for the Replies.

    I have created a job for this task.

    on Step 1 i have copied the script and select the database name and on advanced tab i have on success go to next step and location to the output file.

    Followed the same process for all the databases.

    Looks everything fine:-)

    Regards,

    SAM

    Regards,
    SAM
    ***Share your knowledge.It’s a way to achieve immortality----Dalai Lama***

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply