yes, I can create with schedule() function, only problem is, it take postgres as default database, which I would like to change it to my database, hence I am trying...

Hey Ryan,

I used a role which is member of pg_azure_admin, still I am not able to create a job due to permission denied error.

Thanks,

Naveen J V

Thanks Ryan,

I tried schedule_in_database, but getting the following error:

ERROR: permission denied for function schedule_in_database

Regards,

Naveen J V

It does not give error. It executes.

Thanks Megha.

SELECT would results many thousand rows.

You have re-written the same query with alias, otherwise there is no difference between my query and yours right?

Thanks Gail.

Gail, you are absolutely right.

I have doing a batch delete due to large size of the table. But in case if I get error during delete, how do I capture?

If...

Then, how do we track the errors?

since table is very large, I cannot remove batch delete process.

I wanted some mechanism to track tables successfully deleted and failed.

Thanks,

Naveen J V

SP is also fine, but again SP needs to be called for each table right?

and transaction should be handled with in SP or what?

Rollback only table 30 and loop should continue from 31 onwards

Hi,

I am facing similar issues. Need to export from SQL table to pre-formated excel sheet.

can u please help me by sending the steps. I am a newbie to SSIS.

Thanks in...