Running the FSA Reporting database purging job manually

Article:HOWTO32098  |  Created: 2010-09-23  |  Updated: 2012-06-27  |  Article URL http://www.symantec.com/docs/HOWTO32098
Article Type
How To


Subject


Running the FSA Reporting database purging job manually

FSA Reporting includes a separate FSA Reporting database purging job for each FSA Reporting database. The purging job moves data from the database's main tables to the history tables.

You can run an FSA Reporting database purging job manually if for some reason the job does not run automatically for some time.

To run an FSA Reporting database purging job manually

  1. For the SQL Server that hosts the database or databases that you want to purge, make sure that the status of the SQL Server Agent service is Started.

  2. Start SQL Server Management Studio.

  3. Expand the SQL Server Agent node.

  4. Expand the Jobs node.

  5. Right-click EV FSAReporting Purging Job FSAReporting_db where FSAReporting_db is the name of the database that you want to purge.

    From the shortcut menu select the option Start Job or Start Job At.

    A Start Jobs window opens, and shows the status of the job as the job progresses.

See Maintaining the FSA Reporting databases

See About the FSA Reporting databases

See Managing FSA Reporting


Legacy ID



v40801485_v34981136


Article URL http://www.symantec.com/docs/HOWTO32098


Terms of use for this information are found in Legal Notices