Hello
I have an application with several databases
I want to define a Job that will run an SQL command on a specific table.
For example: Once a month it will delete old records from a table.

Thanks for support
Sorin

Hershcu


All a job is doing is running an sql command so if you can write the sql then it will be run. Since you have multiple databases you will either have to use the USE - have a look in the manual - or preface the table with the database name. That should be all.

Roy Lambert