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